APPS.XDPCORE_WI dependencies on XDP_FULFILL_WORKLIST

Line 16: from XDP_FULFILL_WORKLIST

12:
13:
14: cursor c_WIList (OrderID number, LineItemID number, prov_seq number) is
15: select WORKITEM_INSTANCE_ID, WORKITEM_ID, PRIORITY, WI_SEQUENCE
16: from XDP_FULFILL_WORKLIST
17: where ORDER_ID = OrderID
18: and LINE_ITEM_ID = LineItemID
19: and status_code = 'STANDBY'
20: and WI_SEQUENCE = (

Line 22: from XDP_FULFILL_WORKLIST

18: and LINE_ITEM_ID = LineItemID
19: and status_code = 'STANDBY'
20: and WI_SEQUENCE = (
21: select MIN(WI_SEQUENCE)
22: from XDP_FULFILL_WORKLIST
23: where ORDER_ID = OrderID
24: and LINE_ITEM_ID = LineItemID
25: and status_code = 'STANDBY'
26: and WI_SEQUENCE > prov_seq);