eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XDPCORE_BUNDLE dependencies on XDP_ORDER_LINE_ITEMS

Line 444: from XDP_ORDER_LINE_ITEMS

440: itemkey in varchar2) return varchar2
441: is
442: cursor c_BundleSeq( OrderID number, BundleSeq number) is
443: select BUNDLE_ID
444: from XDP_ORDER_LINE_ITEMS
445: where ORDER_ID = OrderID
446: and STATUS_CODE = 'READY'
447: and BUNDLE_SEQUENCE = (select min(BUNDLE_SEQUENCE)
448: from XDP_ORDER_LINE_ITEMS

Line 448: from XDP_ORDER_LINE_ITEMS

444: from XDP_ORDER_LINE_ITEMS
445: where ORDER_ID = OrderID
446: and STATUS_CODE = 'READY'
447: and BUNDLE_SEQUENCE = (select min(BUNDLE_SEQUENCE)
448: from XDP_ORDER_LINE_ITEMS
449: where ORDER_ID = OrderID
450: and STATUS_CODE = 'READY'
451: and BUNDLE_SEQUENCE > BundleSeq);
452:

Line 531: from XDP_ORDER_LINE_ITEMS

527: l_CurrentBundleSequence number;
528:
529: cursor c_GetIndBundle(OrderID number) is
530: select distinct(NVL(BUNDLE_ID, -1))
531: from XDP_ORDER_LINE_ITEMS
532: where ORDER_ID = OrderID
533: and STATUS_CODE = 'READY'
534: and (BUNDLE_SEQUENCE is null) OR (BUNDLE_SEQUENCE = 0);
535:

Line 538: from XDP_ORDER_LINE_ITEMS

534: and (BUNDLE_SEQUENCE is null) OR (BUNDLE_SEQUENCE = 0);
535:
536: cursor c_GetDepBundle(OrderID number) is
537: select BUNDLE_ID
538: from XDP_ORDER_LINE_ITEMS
539: where ORDER_ID = OrderID
540: and STATUS_CODE = 'READY'
541: and BUNDLE_ID IS NOT NULL
542: and BUNDLE_SEQUENCE > 0;

Line 771: from XDP_ORDER_LINE_ITEMS

767: l_PackageFlag varchar(1);
768:
769: cursor c_GetIndLinesNullBundle(OrderID number) is
770: select LINE_ITEM_ID, IS_PACKAGE_FLAG
771: from XDP_ORDER_LINE_ITEMS
772: where ORDER_ID = OrderID
773: and IS_VIRTUAL_LINE_FLAG = 'N'
774: and STATUS_CODE = 'READY'
775: and BUNDLE_ID is null

Line 780: from XDP_ORDER_LINE_ITEMS

776: and LINE_SEQUENCE = 0;
777:
778: cursor c_GetDepLinesNullBundle(OrderID number) is
779: select LINE_ITEM_ID, IS_PACKAGE_FLAG
780: from XDP_ORDER_LINE_ITEMS
781: where ORDER_ID = OrderID
782: and IS_VIRTUAL_LINE_FLAG = 'N'
783: and STATUS_CODE = 'READY'
784: and BUNDLE_ID is null

Line 790: from XDP_ORDER_LINE_ITEMS

786:
787:
788: cursor c_GetIndLinesForBundle(OrderID number, BundleID number) is
789: select LINE_ITEM_ID, IS_PACKAGE_FLAG
790: from XDP_ORDER_LINE_ITEMS
791: where ORDER_ID = OrderID
792: and IS_VIRTUAL_LINE_FLAG = 'N'
793: and STATUS_CODE = 'READY'
794: and BUNDLE_ID = BundleID

Line 799: from XDP_ORDER_LINE_ITEMS

795: and LINE_SEQUENCE = 0;
796:
797: cursor c_GetDepLinesForBundle(OrderID number, BundleID number) is
798: select LINE_ITEM_ID, IS_PACKAGE_FLAG
799: from XDP_ORDER_LINE_ITEMS
800: where ORDER_ID = OrderID
801: and IS_VIRTUAL_LINE_FLAG = 'N'
802: and STATUS_CODE = 'READY'
803: and BUNDLE_ID = BundleID

Line 1234: from XDP_ORDER_LINE_ITEMS

1230:
1231: is
1232: cursor c_BundleSeq( OrderID number, BundleSeq number) is
1233: select DISTINCT(BUNDLE_ID), BUNDLE_SEQUENCE
1234: from XDP_ORDER_LINE_ITEMS
1235: where ORDER_ID = OrderID
1236: and STATUS_CODE = 'READY'
1237: and BUNDLE_ID >= 0
1238: and BUNDLE_SEQUENCE = (select min(BUNDLE_SEQUENCE)

Line 1239: from XDP_ORDER_LINE_ITEMS

1235: where ORDER_ID = OrderID
1236: and STATUS_CODE = 'READY'
1237: and BUNDLE_ID >= 0
1238: and BUNDLE_SEQUENCE = (select min(BUNDLE_SEQUENCE)
1239: from XDP_ORDER_LINE_ITEMS
1240: where ORDER_ID = OrderID
1241: and STATUS_CODE = 'READY'
1242: and BUNDLE_ID >= 0
1243: and BUNDLE_SEQUENCE > BundleSeq);

Line 1257: from XDP_ORDER_LINE_ITEMS

1253: l_tempKey varchar2(240);
1254:
1255: cursor c_GetIndLinesForBundle(OrderID number, BundleID number) is
1256: select LINE_ITEM_ID, IS_PACKAGE_FLAG
1257: from XDP_ORDER_LINE_ITEMS
1258: where ORDER_ID = OrderID
1259: and IS_VIRTUAL_LINE_FLAG = 'N'
1260: and STATUS_CODE = 'READY'
1261: and BUNDLE_ID = BundleID

Line 1266: from XDP_ORDER_LINE_ITEMS

1262: and LINE_SEQUENCE = 0;
1263:
1264: cursor c_GetDepLinesForBundle(OrderID number, BundleID number) is
1265: select LINE_ITEM_ID, IS_PACKAGE_FLAG
1266: from XDP_ORDER_LINE_ITEMS
1267: where ORDER_ID = OrderID
1268: and IS_VIRTUAL_LINE_FLAG = 'N'
1269: and STATUS_CODE = 'READY'
1270: and BUNDLE_ID = BundleID

Line 1564: from XDP_ORDER_LINE_ITEMS

1560: l_DepFound number := 0;
1561:
1562: cursor c_GetIndBundles(OrderID number) is
1563: select 'Y'
1564: from XDP_ORDER_LINE_ITEMS
1565: where ORDER_ID = OrderID
1566: and STATUS_CODE = 'READY'
1567: and ( (BUNDLE_SEQUENCE is null) OR (BUNDLE_SEQUENCE = 0));
1568:

Line 1571: from XDP_ORDER_LINE_ITEMS

1567: and ( (BUNDLE_SEQUENCE is null) OR (BUNDLE_SEQUENCE = 0));
1568:
1569: cursor c_GetDepBundles(OrderID number) is
1570: select 'Y'
1571: from XDP_ORDER_LINE_ITEMS
1572: where ORDER_ID = OrderID
1573: and STATUS_CODE = 'READY'
1574: and BUNDLE_ID IS NOT NULL
1575: and BUNDLE_SEQUENCE > 0;

Line 1622: from XDP_ORDER_LINE_ITEMS

1618: l_result varchar2(1) := 'N';
1619:
1620: cursor c_GetIndBundles(OrderID number) is
1621: select distinct(NVL(BUNDLE_ID, -1)) BUNDLE_ID
1622: from XDP_ORDER_LINE_ITEMS
1623: where ORDER_ID = OrderID
1624: and STATUS_CODE = 'READY'
1625: and ((BUNDLE_SEQUENCE is null) OR (BUNDLE_SEQUENCE = 0));
1626:

Line 1747: from XDP_ORDER_LINE_ITEMS

1743: l_tempKey varchar2(240);
1744:
1745: cursor c_BundleSeq( OrderID number, BundleSeq number) is
1746: select DISTINCT(BUNDLE_ID) BUNDLE_ID, BUNDLE_SEQUENCE
1747: from XDP_ORDER_LINE_ITEMS
1748: where ORDER_ID = OrderID
1749: and STATUS_CODE = 'READY'
1750: and BUNDLE_ID >= 0
1751: and BUNDLE_SEQUENCE = (select min(BUNDLE_SEQUENCE)

Line 1752: from XDP_ORDER_LINE_ITEMS

1748: where ORDER_ID = OrderID
1749: and STATUS_CODE = 'READY'
1750: and BUNDLE_ID >= 0
1751: and BUNDLE_SEQUENCE = (select min(BUNDLE_SEQUENCE)
1752: from XDP_ORDER_LINE_ITEMS
1753: where ORDER_ID = OrderID
1754: and STATUS_CODE = 'READY'
1755: and BUNDLE_ID >= 0
1756: and BUNDLE_SEQUENCE > BundleSeq);

Line 1867: from XDP_ORDER_LINE_ITEMS

1863: x_Progress VARCHAR2(2000);
1864:
1865: cursor c_GetIndLinesNullBundle(OrderID number) is
1866: select 'Y'
1867: from XDP_ORDER_LINE_ITEMS
1868: where ORDER_ID = OrderID
1869: and IS_VIRTUAL_LINE_FLAG = 'N'
1870: and STATUS_CODE = 'READY'
1871: and BUNDLE_ID is null

Line 1877: from XDP_ORDER_LINE_ITEMS

1873:
1874:
1875: cursor c_GetDepLinesNullBundle(OrderID number) is
1876: select 'Y'
1877: from XDP_ORDER_LINE_ITEMS
1878: where ORDER_ID = OrderID
1879: and IS_VIRTUAL_LINE_FLAG = 'N'
1880: and STATUS_CODE = 'READY'
1881: and BUNDLE_ID is null

Line 1886: from XDP_ORDER_LINE_ITEMS

1882: and LINE_SEQUENCE > 0;
1883:
1884: cursor c_GetIndLinesForBundle(OrderID number, BundleID number) is
1885: select 'Y'
1886: from XDP_ORDER_LINE_ITEMS
1887: where ORDER_ID = OrderID
1888: and IS_VIRTUAL_LINE_FLAG = 'N'
1889: and STATUS_CODE = 'READY'
1890: and BUNDLE_ID = BundleID

Line 1896: from XDP_ORDER_LINE_ITEMS

1892:
1893:
1894: cursor c_GetDepLinesForBundle(OrderID number, BundleID number) is
1895: select 'Y'
1896: from XDP_ORDER_LINE_ITEMS
1897: where ORDER_ID = OrderID
1898: and IS_VIRTUAL_LINE_FLAG = 'N'
1899: and STATUS_CODE = 'READY'
1900: and BUNDLE_ID = BundleID