DBA Data[Home] [Help]

APPS.OE_RMA_RECEIVING dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 1224: wf_item_activity_statuses wf,

1220:
1221: SELECT l.line_id
1222: INTO l_open_line_id
1223: FROM oe_order_lines l,
1224: wf_item_activity_statuses wf,
1225: wf_process_activities wpa
1226: WHERE l.open_flag = 'Y'
1227: and wpa.activity_item_type='OEOL'
1228: and wpa.activity_name='RMA_WAIT_FOR_RECEIVING'

Line 1296: wf_item_activity_statuses wf,

1292: /* this line is closed, or AR interfaced, or fully received */
1293: select l.ordered_quantity
1294: into x_quantity
1295: from oe_order_lines_all l,
1296: wf_item_activity_statuses wf,
1297: wf_process_activities wpa
1298: where l.open_flag = 'Y'
1299: and wpa.activity_item_type='OEOL'
1300: and wpa.activity_name='RMA_WAIT_FOR_RECEIVING'