sql
-
编辑 删除
R12 view no data
beginfnd_global.apps_initialize(&user_id,&responsibility_id,&org_id);mo_global.init('PO');end;To get org id, user id and responsibility id:select user_id from fnd_user where user_name = ;select responsibility_id from fnd_responsibility_tl where responsibility_name = ;select organization_id f...
-
编辑 删除
ap supplier bank query
-- supplier level:SELECT distinct 'Bank Account at Supplier Level',ss.org_id , sup.vendor_id vendor_id, sup.party_id &nbs...
