DBA Data[Home] [Help]

APPS.OE_RMA_RECEIVING dependencies on WF_PROCESS_ACTIVITIES

Line 1334: wf_process_activities wpa

1330: SELECT l.line_id
1331: INTO l_open_line_id
1332: FROM oe_order_lines l,
1333: wf_item_activity_statuses wf,
1334: wf_process_activities wpa
1335: WHERE l.open_flag = 'Y'
1336: and wpa.activity_item_type='OEOL'
1337: and wpa.activity_name='RMA_WAIT_FOR_RECEIVING'
1338: and wf.item_type='OEOL'

Line 1406: wf_process_activities wpa

1402: select l.ordered_quantity
1403: into x_quantity
1404: from oe_order_lines_all l,
1405: wf_item_activity_statuses wf,
1406: wf_process_activities wpa
1407: where l.open_flag = 'Y'
1408: and wpa.activity_item_type='OEOL'
1409: and wpa.activity_name='RMA_WAIT_FOR_RECEIVING'
1410: and wf.item_type='OEOL'