APPS.XDPCORE_LINE dependencies on XDP_ORDER_LINE_ITEMS

Line 18: from XDP_ORDER_LINE_ITEMS

14:
15: cursor c_LineSeqNullBundle(OrderID number, LineSeq number) is
16: select LINE_ITEM_ID, LINE_NUMBER, LINE_ITEM_NAME, IS_PACKAGE_FLAG, LINE_SEQUENCE ,
17: IB_SOURCE , NVL(IB_SOURCE_ID,-999) IB_SOURCE_ID
18: from XDP_ORDER_LINE_ITEMS
19: where ORDER_ID = OrderID
20: and status_code = 'READY'
21: and IS_VIRTUAL_LINE_FLAG = 'N'
22: and BUNDLE_ID is null

Line 25: from XDP_ORDER_LINE_ITEMS

21: and IS_VIRTUAL_LINE_FLAG = 'N'
22: and BUNDLE_ID is null
23: and LINE_SEQUENCE = (
24: select MIN(LINE_SEQUENCE)
25: from XDP_ORDER_LINE_ITEMS
26: where ORDER_ID = OrderID
27: and status_code = 'READY'
28: and IS_VIRTUAL_LINE_FLAG = 'N'
29: and BUNDLE_ID is null

Line 35: from XDP_ORDER_LINE_ITEMS

31:
32: cursor c_LineSeqForBundle(OrderID number, BundleID number, LineSeq number) is
33: select LINE_ITEM_ID, LINE_NUMBER, LINE_ITEM_NAME, IS_PACKAGE_FLAG, LINE_SEQUENCE ,
34: IB_SOURCE , NVL(IB_SOURCE_ID,-999) IB_SOURCE_ID
35: from XDP_ORDER_LINE_ITEMS
36: where ORDER_ID = OrderID
37: and status_code = 'READY'
38: and IS_VIRTUAL_LINE_FLAG = 'N'
39: and BUNDLE_ID = BundleID

Line 42: from XDP_ORDER_LINE_ITEMS

38: and IS_VIRTUAL_LINE_FLAG = 'N'
39: and BUNDLE_ID = BundleID
40: and LINE_SEQUENCE = (
41: select MIN(LINE_SEQUENCE)
42: from XDP_ORDER_LINE_ITEMS
43: where ORDER_ID = OrderID
44: and status_code = 'READY'
45: and IS_VIRTUAL_LINE_FLAG = 'N'
46: and BUNDLE_ID = BundleID

Line 52: from XDP_ORDER_LINE_ITEMS

48:
49: cursor c_LineSeq(OrderID number, LineSeq number) is
50: select LINE_ITEM_ID, LINE_NUMBER, LINE_ITEM_NAME, IS_PACKAGE_FLAG, LINE_SEQUENCE,
51: IB_SOURCE,NVL(IB_SOURCE_ID,-999) IB_SOURCE_ID
52: from XDP_ORDER_LINE_ITEMS
53: where ORDER_ID = OrderID
54: and status_code = 'READY'
55: and IS_VIRTUAL_LINE_FLAG = 'N'
56: and LINE_SEQUENCE = (

Line 58: from XDP_ORDER_LINE_ITEMS

54: and status_code = 'READY'
55: and IS_VIRTUAL_LINE_FLAG = 'N'
56: and LINE_SEQUENCE = (
57: select MIN(LINE_SEQUENCE)
58: from XDP_ORDER_LINE_ITEMS
59: where ORDER_ID = OrderID
60: and status_code = 'READY'
61: and IS_VIRTUAL_LINE_FLAG = 'N'
62: and LINE_SEQUENCE > LineSeq);