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.OE_HOLDS_PUB dependencies on OE_ORDER_HOLDS

Line 137: FROM OE_ORDER_HOLDS OH

133: AND HS.HOLD_ID = p_hold_source_rec.hold_id
134: AND HS.RELEASED_FLAG = 'N'
135: AND NVL(HS.HOLD_UNTIL_DATE, SYSDATE + 1) > SYSDATE
136: AND exists (SELECT 'x'
137: FROM OE_ORDER_HOLDS OH
138: WHERE OH.LINE_ID = p_hold_source_rec.line_id
139: AND OH.HOLD_SOURCE_ID = HS.HOLD_SOURCE_ID);
140: else
141: UPDATE OE_HOLD_SOURCES

Line 1064: FROM OE_ORDER_HOLDS

1060: -- Check for duplicate hold
1061: BEGIN
1062: SELECT 'Duplicate Hold'
1063: INTO l_dummy
1064: FROM OE_ORDER_HOLDS
1065: WHERE hold_source_id = l_hold_source_id
1066: AND HEADER_ID = l_header_id
1067: AND NVL(LINE_ID, NVL(p_line_id,0)) = NVL(p_line_id, 0)
1068: AND HOLD_RELEASE_ID IS NULL

Line 1245: FROM oe_order_holds_all oh

1241: BEGIN
1242:
1243: SELECT 'ANY_LINE_HOLD'
1244: INTO l_dummy
1245: FROM oe_order_holds_all oh
1246: WHERE oh.header_id = p_hdr_id
1247: and oh.line_id = p_line_id
1248: and oh.hold_release_id is null
1249: AND EXISTS

Line 1372: FROM oe_order_holds_all oh

1368: BEGIN
1369:
1370: SELECT /* MOAC_SQL_CHANGE */ 'ANY_ATO_LINE_HOLD'
1371: INTO l_dummy
1372: FROM oe_order_holds_all oh
1373: WHERE oh.header_id = p_hdr_id
1374: and oh.line_id in (select ol.line_id from oe_order_lines_all ol
1375: where ol.header_id = oh.header_id
1376: and ol.ato_line_id = p_ato_line_id

Line 1499: FROM oe_order_holds_all oh

1495: BEGIN
1496:
1497: SELECT /* MOAC_SQL_CHANGE */ 'ANY_SMC_LINE_HOLD'
1498: INTO l_dummy
1499: FROM oe_order_holds_all oh
1500: WHERE oh.header_id = p_hdr_id
1501: and oh.line_id in (select ol.line_id from oe_order_lines_all ol
1502: where ol.header_id = oh.header_id
1503: and ol.top_model_line_id = p_top_model_line_id)

Line 1608: FROM oe_order_holds_all oh

1604: BEGIN
1605:
1606: SELECT 'ANY_LINE_HOLD'
1607: INTO l_dummy
1608: FROM oe_order_holds_all oh
1609: WHERE oh.header_id = x_hold_rec.header_id
1610: and OH.LINE_ID is not null
1611: and OH.HOLD_RELEASE_ID IS NULL
1612: and ROWNUM = 1

Line 1823: FROM oe_order_holds_all oh

1819: BEGIN
1820:
1821: SELECT 'ANY_HEADER_HOLD'
1822: INTO l_dummy
1823: FROM oe_order_holds_all oh
1824: WHERE oh.header_id = p_hdr_id
1825: AND oh.line_id IS NULL
1826: AND oh.hold_release_id IS NULL
1827: AND EXISTS

Line 2389: FROM OE_HOLD_SOURCES HS, OE_ORDER_HOLDS OH

2385:
2386: -- Define Cursors
2387: CURSOR hold_source IS
2388: SELECT HS.HOLD_SOURCE_ID,OH.ORDER_HOLD_ID
2389: FROM OE_HOLD_SOURCES HS, OE_ORDER_HOLDS OH
2390: WHERE HS.HOLD_ID = p_hold_id
2391: AND HS.RELEASED_FLAG = 'N'
2392: AND NVL(HS.HOLD_UNTIL_DATE, SYSDATE + 1) > SYSDATE
2393: AND HS.HOLD_ENTITY_CODE = p_entity_code

Line 2405: FROM OE_ORDER_HOLDS OH

2401: AND NVL(OH.LINE_ID, 0) = NVL(NVL(p_line_id, OH.LINE_ID), 0)
2402: AND OH.HOLD_RELEASE_ID IS NULL;
2403: CURSOR order_hold IS
2404: SELECT OH.ORDER_HOLD_ID
2405: FROM OE_ORDER_HOLDS OH
2406: WHERE OH.HOLD_SOURCE_ID = l_hold_source_id
2407: AND NVL(OH.HEADER_ID, 0) = NVL(NVL(p_header_id, OH.HEADER_ID), 0)
2408: AND NVL(OH.LINE_ID, 0) = NVL(NVL(p_line_id, OH.LINE_ID), 0)
2409: AND OH.HOLD_RELEASE_ID IS NULL;

Line 2601: -- Deletes from OE_ORDER_HOLDS all hold records for an order (p_header_id)

2597:
2598:
2599: ----------------------------------------------------------------------------
2600: -- Delete Holds
2601: -- Deletes from OE_ORDER_HOLDS all hold records for an order (p_header_id)
2602: -- or for a line (p_line_id).
2603: -- Also, if there are ORDER hold sources (hold_entity_code = 'O') for this
2604: -- order, deletes hold source records from OE_HOLD_SOURCES.
2605: -- If the hold or hold source was released and the same release record is

Line 2626: FROM OE_ORDER_HOLDS

2622: l_org_id number;
2623:
2624: CURSOR order_hold IS
2625: SELECT order_hold_id, NVL(hold_release_id,0)
2626: FROM OE_ORDER_HOLDS
2627: WHERE HEADER_ID = p_header_id;
2628: CURSOR hold_source IS
2629: SELECT hold_source_id, NVL(hold_release_id,0)
2630: FROM OE_HOLD_SOURCES

Line 2635: FROM OE_ORDER_HOLDS

2631: WHERE HOLD_ENTITY_CODE = 'O'
2632: AND HOLD_ENTITY_ID = p_header_id;
2633: CURSOR line_hold IS
2634: SELECT order_hold_id, NVL(hold_release_id,0)
2635: FROM OE_ORDER_HOLDS
2636: WHERE LINE_ID = p_line_id;
2637:
2638: --ER#7479609 start
2639: CURSOR line_hold_opt_item(p_top_model_line_id NUMBER,p_inventory_item_id NUMBER) IS

Line 2641: FROM OE_ORDER_HOLDS OH,OE_HOLD_SOURCES HS,OE_ORDER_LINES OL

2637:
2638: --ER#7479609 start
2639: CURSOR line_hold_opt_item(p_top_model_line_id NUMBER,p_inventory_item_id NUMBER) IS
2640: SELECT OH.order_hold_id, NVL(OH.hold_release_id,0)
2641: FROM OE_ORDER_HOLDS OH,OE_HOLD_SOURCES HS,OE_ORDER_LINES OL
2642: WHERE OH.LINE_ID = p_top_model_line_id
2643: AND OH.LINE_ID = OL.LINE_ID
2644: AND OH.hold_source_id=HS.hold_source_id
2645: AND HS.hold_entity_id=OL.inventory_item_id

Line 2682: -- Delete the hold records corr. to this order or line in OE_ORDER_HOLDS

2678: RAISE FND_API.G_EXC_ERROR;
2679:
2680: END IF;
2681:
2682: -- Delete the hold records corr. to this order or line in OE_ORDER_HOLDS
2683: IF p_line_id = FND_API.G_MISS_NUM THEN
2684:
2685: -- Delete order hold records
2686: OPEN order_hold;

Line 2697: DELETE FROM OE_ORDER_HOLDS

2693: IF l_debug_level > 0 THEN
2694: oe_debug_pub.add( 'DELETING ORDER HOLD RECORD' ) ;
2695: END IF;
2696:
2697: DELETE FROM OE_ORDER_HOLDS
2698: WHERE order_hold_id = l_order_hold_id;
2699:
2700: IF l_debug_level > 0 THEN
2701: oe_debug_pub.add( 'DELETING HOLD RELEASE RECORD' ) ;

Line 2710: FROM OE_ORDER_HOLDS

2706:
2707: /* DELETE FROM OE_HOLD_RELEASES
2708: WHERE HOLD_RELEASE_ID = l_hold_release_id
2709: AND HOLD_RELEASE_ID NOT IN (SELECT NVL(HOLD_RELEASE_ID,0)
2710: FROM OE_ORDER_HOLDS
2711: UNION
2712: SELECT NVL(HOLD_RELEASE_ID,0)
2713: FROM OE_HOLD_SOURCES
2714: ); */

Line 2758: DELETE FROM OE_ORDER_HOLDS

2754: IF l_debug_level > 0 THEN
2755: oe_debug_pub.add( 'DELETING LINE HOLD RECORD' ) ;
2756: END IF;
2757:
2758: DELETE FROM OE_ORDER_HOLDS
2759: WHERE order_hold_id = l_order_hold_id;
2760:
2761: DELETE FROM OE_HOLD_RELEASES
2762: WHERE HOLD_RELEASE_ID = l_hold_release_id

Line 2767: FROM OE_ORDER_HOLDS

2763: AND ORDER_HOLD_ID = l_order_hold_id;
2764:
2765: /* AND HOLD_RELEASE_ID NOT IN
2766: (SELECT NVL(HOLD_RELEASE_ID,0)
2767: FROM OE_ORDER_HOLDS
2768: UNION
2769: SELECT NVL(HOLD_RELEASE_ID,0)
2770: FROM OE_HOLD_SOURCES
2771: ); */

Line 2796: DELETE FROM OE_ORDER_HOLDS

2792: IF l_debug_level > 0 THEN
2793: oe_debug_pub.add( 'DELETING LINE HOLD RECORD FOR TOP MODEL WHEN OPTION ITEM LINE IS DELETED' ) ;
2794: END IF;
2795:
2796: DELETE FROM OE_ORDER_HOLDS
2797: WHERE order_hold_id = l_order_hold_id;
2798:
2799: DELETE FROM OE_HOLD_RELEASES
2800: WHERE HOLD_RELEASE_ID = l_hold_release_id

Line 2915: FROM OE_HOLD_SOURCES HS, OE_ORDER_HOLDS OH

2911: --ER#7479609 CURSOR prev_hold IS
2912: CURSOR prev_hold(l_all_del_pay VARCHAR2) IS --ER#7479609
2913: --ER#7479609 SELECT HS.hold_entity_id, OH.order_hold_id
2914: SELECT HS.hold_entity_id, OH.order_hold_id,HS.hold_entity_code --ER#7479609
2915: FROM OE_HOLD_SOURCES HS, OE_ORDER_HOLDS OH
2916: WHERE OH.HEADER_ID = l_header_id
2917: AND NVL(OH.LINE_ID,FND_API.G_MISS_NUM) =
2918: NVL(l_line_id,FND_API.G_MISS_NUM)
2919: AND OH.HOLD_SOURCE_ID = HS.HOLD_SOURCE_ID

Line 2928: FROM OE_HOLD_SOURCES HS, OE_ORDER_HOLDS OH

2924: --ER#7479609 CURSOR prev_hold_entity2 IS
2925: CURSOR prev_hold_entity2(l_all_del_pay VARCHAR2) IS --ER#7479609
2926: --ER#7479609 SELECT HS.hold_entity_id, OH.order_hold_id
2927: SELECT HS.hold_entity_id, OH.order_hold_id,HS.hold_entity_code2 --ER#7479609
2928: FROM OE_HOLD_SOURCES HS, OE_ORDER_HOLDS OH
2929: WHERE OH.HEADER_ID = l_header_id
2930: AND NVL(OH.LINE_ID,FND_API.G_MISS_NUM) =
2931: NVL(l_line_id,FND_API.G_MISS_NUM)
2932: AND OH.HOLD_SOURCE_ID = HS.HOLD_SOURCE_ID

Line 3176: DELETE FROM OE_ORDER_HOLDS

3172: --ER#7479609 end
3173: IF l_debug_level > 0 THEN
3174: oe_debug_pub.add( 'DELETING HOLD' , 1 ) ;
3175: END IF;
3176: DELETE FROM OE_ORDER_HOLDS
3177: WHERE ORDER_HOLD_ID = l_order_hold_id;
3178:
3179: IF l_debug_level > 0 THEN
3180: oe_debug_pub.add( 'L_HOLD_ENTITY_ID/P_HOLD_ENTITY_ID/L_ORDER_HOLD_ID:' || L_HOLD_ENTITY_ID || '/' || P_HOLD_ENTITY_ID || '/' || L_ORDER_HOLD_ID ) ;

Line 3242: DELETE FROM OE_ORDER_HOLDS

3238: --ER#7479609 end
3239: IF l_debug_level > 0 THEN
3240: oe_debug_pub.add( 'DELETING HOLD' , 1 ) ;
3241: END IF;
3242: DELETE FROM OE_ORDER_HOLDS
3243: WHERE ORDER_HOLD_ID = l_order_hold_id;
3244:
3245: IF l_debug_level > 0 THEN
3246: oe_debug_pub.add( 'L_HOLD_ENTITY_ID/P_HOLD_ENTITY_ID/L_ORDER_HOLD_ID:' || L_HOLD_ENTITY_ID || '/' || P_HOLD_ENTITY_ID || '/' || L_ORDER_HOLD_ID ) ;