DBA Data[Home] [Help]

APPS.CSM_MTL_SYSTEM_ITEMS_EVENT_PKG dependencies on OE_ORDER_LINES_ALL

Line 1093: oe_order_lines_all c,csp_requirement_headers d

1089: IS
1090: SELECT csm_mtl_system_items_acc_s.NEXTVAL,inventory_item_id,org_id ,user_id
1091: FROM ( select c.inventory_item_id,d.destination_organization_id org_id ,a.user_id
1092: from csm_req_lines_acc a, csp_req_line_details b ,
1093: oe_order_lines_all c,csp_requirement_headers d
1094: ,csp_requirement_lines e ,asg_user au
1095: where a.requirement_line_id=b.requirement_line_id
1096: and b.source_type= 'IO' and b.source_id=c.line_id
1097: and au.user_id=a.user_id and au.multi_platform='Y'