APPS.ONT_OEXOECCH_XMLP_PKG dependencies on OE_ORDER_HOLDS

Line 831: OE_ORDER_HOLDS OH

827: AND not exists (
828: SELECT
829: 'x'
830: FROM
831: OE_ORDER_HOLDS OH
832: WHERE OH.HEADER_ID = H.HEADER_ID
833: AND OH.HOLD_RELEASE_ID is null );
834: DEBUG := 28;
835: SELECT

Line 873: OE_ORDER_HOLDS OH

869: AND not exists (
870: SELECT
871: 'x'
872: FROM
873: OE_ORDER_HOLDS OH
874: WHERE OH.HEADER_ID = H.HEADER_ID
875: AND OH.HOLD_RELEASE_ID is null );
876: L_UNINV_ORD_CREDIT := L_TOTAL1_CREDIT + L_TOTAL3_CREDIT;
877: END IF;

Line 996: OE_ORDER_HOLDS OH

992: AND not exists (
993: SELECT
994: 'x'
995: FROM
996: OE_ORDER_HOLDS OH
997: WHERE OH.HEADER_ID = H.HEADER_ID
998: AND OH.HOLD_RELEASE_ID is null );
999: DEBUG := 33;
1000: SELECT

Line 1038: OE_ORDER_HOLDS OH

1034: AND not exists (
1035: SELECT
1036: 'x'
1037: FROM
1038: OE_ORDER_HOLDS OH
1039: WHERE OH.HEADER_ID = H.HEADER_ID
1040: AND OH.HOLD_RELEASE_ID is null );
1041: L_UNINV_ORD_CREDIT := L_TOTAL1_CREDIT + L_TOTAL3_CREDIT;
1042: END IF;

Line 1163: OE_ORDER_HOLDS OH

1159: AND not exists (
1160: SELECT
1161: 'x'
1162: FROM
1163: OE_ORDER_HOLDS OH
1164: WHERE OH.HEADER_ID = H.HEADER_ID
1165: AND OH.HOLD_RELEASE_ID is null );
1166: DEBUG := 38;
1167: SELECT

Line 1205: OE_ORDER_HOLDS OH

1201: AND not exists (
1202: SELECT
1203: 'x'
1204: FROM
1205: OE_ORDER_HOLDS OH
1206: WHERE OH.HEADER_ID = H.HEADER_ID
1207: AND OH.HOLD_RELEASE_ID is null );
1208: L_UNINV_ORD_SHIP := L_TOTAL1_SHIP + L_TOTAL3_SHIP;
1209: END IF;

Line 1328: OE_ORDER_HOLDS OH

1324: AND not exists (
1325: SELECT
1326: 'x'
1327: FROM
1328: OE_ORDER_HOLDS OH
1329: WHERE OH.HEADER_ID = H.HEADER_ID
1330: AND OH.HOLD_RELEASE_ID is null );
1331: DEBUG := 43;
1332: SELECT

Line 1370: OE_ORDER_HOLDS OH

1366: AND not exists (
1367: SELECT
1368: 'x'
1369: FROM
1370: OE_ORDER_HOLDS OH
1371: WHERE OH.HEADER_ID = H.HEADER_ID
1372: AND OH.HOLD_RELEASE_ID is null );
1373: L_UNINV_ORD_SHIP := L_TOTAL1_SHIP + L_TOTAL3_SHIP;
1374: END IF;

Line 1803: OE_ORDER_HOLDS OH

1799: AND not exists (
1800: SELECT
1801: 'x'
1802: FROM
1803: OE_ORDER_HOLDS OH
1804: WHERE OH.HEADER_ID = H.HEADER_ID
1805: AND OH.HOLD_RELEASE_ID is null );
1806: DEBUG := 70;
1807: SELECT

Line 1845: OE_ORDER_HOLDS OH

1841: AND not exists (
1842: SELECT
1843: 'x'
1844: FROM
1845: OE_ORDER_HOLDS OH
1846: WHERE OH.HEADER_ID = H.HEADER_ID
1847: AND OH.HOLD_RELEASE_ID is null );
1848: L_UNINV_ORD_PICK := L_TOTAL1_PICK + L_TOTAL3_PICK;
1849: END IF;

Line 1968: OE_ORDER_HOLDS OH

1964: AND not exists (
1965: SELECT
1966: 'x'
1967: FROM
1968: OE_ORDER_HOLDS OH
1969: WHERE OH.HEADER_ID = H.HEADER_ID
1970: AND OH.HOLD_RELEASE_ID is null );
1971: DEBUG := 76;
1972: SELECT

Line 2010: OE_ORDER_HOLDS OH

2006: AND not exists (
2007: SELECT
2008: 'x'
2009: FROM
2010: OE_ORDER_HOLDS OH
2011: WHERE OH.HEADER_ID = H.HEADER_ID
2012: AND OH.HOLD_RELEASE_ID is null );
2013: L_UNINV_ORD_PICK := L_TOTAL1_PICK + L_TOTAL3_PICK;
2014: END IF;

Line 2135: OE_ORDER_HOLDS OH

2131: AND not exists (
2132: SELECT
2133: 'x'
2134: FROM
2135: OE_ORDER_HOLDS OH
2136: WHERE OH.HEADER_ID = H.HEADER_ID
2137: AND OH.HOLD_RELEASE_ID is null );
2138: DEBUG := 81;
2139: SELECT

Line 2177: OE_ORDER_HOLDS OH

2173: AND not exists (
2174: SELECT
2175: 'x'
2176: FROM
2177: OE_ORDER_HOLDS OH
2178: WHERE OH.HEADER_ID = H.HEADER_ID
2179: AND OH.HOLD_RELEASE_ID is null );
2180: L_UNINV_ORD_PACK := L_TOTAL1_PACK + L_TOTAL3_PACK;
2181: END IF;

Line 2300: OE_ORDER_HOLDS OH

2296: AND not exists (
2297: SELECT
2298: 'x'
2299: FROM
2300: OE_ORDER_HOLDS OH
2301: WHERE OH.HEADER_ID = H.HEADER_ID
2302: AND OH.HOLD_RELEASE_ID is null );
2303: DEBUG := 86;
2304: SELECT

Line 2342: OE_ORDER_HOLDS OH

2338: AND not exists (
2339: SELECT
2340: 'x'
2341: FROM
2342: OE_ORDER_HOLDS OH
2343: WHERE OH.HEADER_ID = H.HEADER_ID
2344: AND OH.HOLD_RELEASE_ID is null );
2345: L_UNINV_ORD_PACK := L_TOTAL1_PACK + L_TOTAL3_PACK;
2346: END IF;