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 147: FROM OE_ORDER_HOLDS OH

143: AND HS.HOLD_ID = p_hold_source_rec.hold_id
144: AND HS.RELEASED_FLAG = 'N'
145: AND NVL(HS.HOLD_UNTIL_DATE, SYSDATE + 1) > SYSDATE
146: AND exists (SELECT 'x'
147: FROM OE_ORDER_HOLDS OH
148: WHERE OH.LINE_ID = p_hold_source_rec.line_id
149: AND OH.HOLD_SOURCE_ID = HS.HOLD_SOURCE_ID);
150: else
151: --ER 12363706, WHO Columns added

Line 1152: FROM OE_ORDER_HOLDS

1148: -- Check for duplicate hold
1149: BEGIN
1150: SELECT 'Duplicate Hold'
1151: INTO l_dummy
1152: FROM OE_ORDER_HOLDS
1153: WHERE hold_source_id = l_hold_source_id
1154: AND HEADER_ID = l_header_id
1155: AND NVL(LINE_ID, NVL(p_line_id,0)) = NVL(p_line_id, 0)
1156: AND HOLD_RELEASE_ID IS NULL

Line 1334: FROM oe_order_holds_all oh

1330: BEGIN
1331:
1332: SELECT 'ANY_LINE_HOLD'
1333: INTO l_dummy
1334: FROM oe_order_holds_all oh
1335: WHERE oh.header_id = p_hdr_id
1336: and oh.line_id = p_line_id
1337: and oh.hold_release_id is null
1338: AND EXISTS

Line 1461: FROM oe_order_holds_all oh

1457: BEGIN
1458:
1459: SELECT /* MOAC_SQL_CHANGE */ 'ANY_ATO_LINE_HOLD'
1460: INTO l_dummy
1461: FROM oe_order_holds_all oh
1462: WHERE oh.header_id = p_hdr_id
1463: and oh.line_id in (select ol.line_id from oe_order_lines_all ol
1464: where ol.header_id = oh.header_id
1465: and ol.ato_line_id = p_ato_line_id

Line 1588: FROM oe_order_holds_all oh

1584: BEGIN
1585:
1586: SELECT /* MOAC_SQL_CHANGE */ 'ANY_SMC_LINE_HOLD'
1587: INTO l_dummy
1588: FROM oe_order_holds_all oh
1589: WHERE oh.header_id = p_hdr_id
1590: and oh.line_id in (select ol.line_id from oe_order_lines_all ol
1591: where ol.header_id = oh.header_id
1592: and ol.top_model_line_id = p_top_model_line_id)

Line 1697: FROM oe_order_holds_all oh

1693: BEGIN
1694:
1695: SELECT 'ANY_LINE_HOLD'
1696: INTO l_dummy
1697: FROM oe_order_holds_all oh
1698: WHERE oh.header_id = x_hold_rec.header_id
1699: and OH.LINE_ID is not null
1700: and OH.HOLD_RELEASE_ID IS NULL
1701: and ROWNUM = 1

Line 1912: FROM oe_order_holds_all oh

1908: BEGIN
1909:
1910: SELECT 'ANY_HEADER_HOLD'
1911: INTO l_dummy
1912: FROM oe_order_holds_all oh
1913: WHERE oh.header_id = p_hdr_id
1914: AND oh.line_id IS NULL
1915: AND oh.hold_release_id IS NULL
1916: AND EXISTS

Line 2479: FROM OE_HOLD_SOURCES HS, OE_ORDER_HOLDS OH

2475: l_check_authorization_flag varchar2(1):='N'; -- bug 8477694
2476: -- Define Cursors
2477: CURSOR hold_source IS
2478: SELECT HS.HOLD_SOURCE_ID,OH.ORDER_HOLD_ID
2479: FROM OE_HOLD_SOURCES HS, OE_ORDER_HOLDS OH
2480: WHERE HS.HOLD_ID = p_hold_id
2481: AND HS.RELEASED_FLAG = 'N'
2482: AND NVL(HS.HOLD_UNTIL_DATE, SYSDATE + 1) > SYSDATE
2483: AND HS.HOLD_ENTITY_CODE = p_entity_code

Line 2495: FROM OE_ORDER_HOLDS OH

2491: AND NVL(OH.LINE_ID, 0) = NVL(NVL(p_line_id, OH.LINE_ID), 0)
2492: AND OH.HOLD_RELEASE_ID IS NULL;
2493: CURSOR order_hold IS
2494: SELECT OH.ORDER_HOLD_ID
2495: FROM OE_ORDER_HOLDS OH
2496: WHERE OH.HOLD_SOURCE_ID = l_hold_source_id
2497: AND NVL(OH.HEADER_ID, 0) = NVL(NVL(p_header_id, OH.HEADER_ID), 0)
2498: AND NVL(OH.LINE_ID, 0) = NVL(NVL(p_line_id, OH.LINE_ID), 0)
2499: AND OH.HOLD_RELEASE_ID IS NULL;

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

2689:
2690:
2691: ----------------------------------------------------------------------------
2692: -- Delete Holds
2693: -- Deletes from OE_ORDER_HOLDS all hold records for an order (p_header_id)
2694: -- or for a line (p_line_id).
2695: -- Also, if there are ORDER hold sources (hold_entity_code = 'O') for this
2696: -- order, deletes hold source records from OE_HOLD_SOURCES.
2697: -- If the hold or hold source was released and the same release record is

Line 2718: FROM OE_ORDER_HOLDS

2714: l_org_id number;
2715:
2716: CURSOR order_hold IS
2717: SELECT order_hold_id, NVL(hold_release_id,0)
2718: FROM OE_ORDER_HOLDS
2719: WHERE HEADER_ID = p_header_id;
2720: CURSOR hold_source IS
2721: SELECT hold_source_id, NVL(hold_release_id,0)
2722: FROM OE_HOLD_SOURCES

Line 2727: FROM OE_ORDER_HOLDS

2723: WHERE HOLD_ENTITY_CODE = 'O'
2724: AND HOLD_ENTITY_ID = p_header_id;
2725: CURSOR line_hold IS
2726: SELECT order_hold_id, NVL(hold_release_id,0)
2727: FROM OE_ORDER_HOLDS
2728: WHERE LINE_ID = p_line_id;
2729:
2730: --ER#7479609 start
2731: CURSOR line_hold_opt_item(p_top_model_line_id NUMBER,p_inventory_item_id NUMBER) IS

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

2729:
2730: --ER#7479609 start
2731: CURSOR line_hold_opt_item(p_top_model_line_id NUMBER,p_inventory_item_id NUMBER) IS
2732: SELECT OH.order_hold_id, NVL(OH.hold_release_id,0)
2733: FROM OE_ORDER_HOLDS OH,OE_HOLD_SOURCES HS,OE_ORDER_LINES OL
2734: WHERE OH.LINE_ID = p_top_model_line_id
2735: AND OH.LINE_ID = OL.LINE_ID
2736: AND OH.hold_source_id=HS.hold_source_id
2737: AND HS.hold_entity_id=OL.inventory_item_id

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

2770: RAISE FND_API.G_EXC_ERROR;
2771:
2772: END IF;
2773:
2774: -- Delete the hold records corr. to this order or line in OE_ORDER_HOLDS
2775: IF p_line_id = FND_API.G_MISS_NUM THEN
2776:
2777: -- Delete order hold records
2778: OPEN order_hold;

Line 2789: DELETE FROM OE_ORDER_HOLDS

2785: IF l_debug_level > 0 THEN
2786: oe_debug_pub.add( 'DELETING ORDER HOLD RECORD' ) ;
2787: END IF;
2788:
2789: DELETE FROM OE_ORDER_HOLDS
2790: WHERE order_hold_id = l_order_hold_id;
2791:
2792: IF l_debug_level > 0 THEN
2793: oe_debug_pub.add( 'DELETING HOLD RELEASE RECORD' ) ;

Line 2802: FROM OE_ORDER_HOLDS

2798:
2799: /* DELETE FROM OE_HOLD_RELEASES
2800: WHERE HOLD_RELEASE_ID = l_hold_release_id
2801: AND HOLD_RELEASE_ID NOT IN (SELECT NVL(HOLD_RELEASE_ID,0)
2802: FROM OE_ORDER_HOLDS
2803: UNION
2804: SELECT NVL(HOLD_RELEASE_ID,0)
2805: FROM OE_HOLD_SOURCES
2806: ); */

Line 2850: DELETE FROM OE_ORDER_HOLDS

2846: IF l_debug_level > 0 THEN
2847: oe_debug_pub.add( 'DELETING LINE HOLD RECORD' ) ;
2848: END IF;
2849:
2850: DELETE FROM OE_ORDER_HOLDS
2851: WHERE order_hold_id = l_order_hold_id;
2852:
2853: DELETE FROM OE_HOLD_RELEASES
2854: WHERE HOLD_RELEASE_ID = l_hold_release_id

Line 2859: FROM OE_ORDER_HOLDS

2855: AND ORDER_HOLD_ID = l_order_hold_id;
2856:
2857: /* AND HOLD_RELEASE_ID NOT IN
2858: (SELECT NVL(HOLD_RELEASE_ID,0)
2859: FROM OE_ORDER_HOLDS
2860: UNION
2861: SELECT NVL(HOLD_RELEASE_ID,0)
2862: FROM OE_HOLD_SOURCES
2863: ); */

Line 2888: DELETE FROM OE_ORDER_HOLDS

2884: IF l_debug_level > 0 THEN
2885: oe_debug_pub.add( 'DELETING LINE HOLD RECORD FOR TOP MODEL WHEN OPTION ITEM LINE IS DELETED' ) ;
2886: END IF;
2887:
2888: DELETE FROM OE_ORDER_HOLDS
2889: WHERE order_hold_id = l_order_hold_id;
2890:
2891: DELETE FROM OE_HOLD_RELEASES
2892: WHERE HOLD_RELEASE_ID = l_hold_release_id

Line 3013: FROM OE_HOLD_SOURCES HS, OE_ORDER_HOLDS OH

3009: --ER#7479609 CURSOR prev_hold IS
3010: CURSOR prev_hold(l_all_del_pay VARCHAR2) IS --ER#7479609
3011: --ER#7479609 SELECT HS.hold_entity_id, OH.order_hold_id
3012: SELECT HS.hold_entity_id, OH.order_hold_id,HS.hold_entity_code --ER#7479609
3013: FROM OE_HOLD_SOURCES HS, OE_ORDER_HOLDS OH
3014: WHERE OH.HEADER_ID = l_header_id
3015: AND NVL(OH.LINE_ID,FND_API.G_MISS_NUM) =
3016: NVL(l_line_id,FND_API.G_MISS_NUM)
3017: AND OH.HOLD_SOURCE_ID = HS.HOLD_SOURCE_ID

Line 3028: FROM OE_HOLD_SOURCES HS, OE_ORDER_HOLDS OH

3024: --ER#7479609 CURSOR prev_hold_entity2 IS
3025: CURSOR prev_hold_entity2(l_all_del_pay VARCHAR2) IS --ER#7479609
3026: --ER#7479609 SELECT HS.hold_entity_id, OH.order_hold_id
3027: SELECT HS.hold_entity_id, OH.order_hold_id,HS.hold_entity_code2 --ER#7479609
3028: FROM OE_HOLD_SOURCES HS, OE_ORDER_HOLDS OH
3029: WHERE OH.HEADER_ID = l_header_id
3030: AND NVL(OH.LINE_ID,FND_API.G_MISS_NUM) =
3031: NVL(l_line_id,FND_API.G_MISS_NUM)
3032: AND OH.HOLD_SOURCE_ID = HS.HOLD_SOURCE_ID

Line 3306: DELETE FROM OE_ORDER_HOLDS

3302: --ER#7479609 end
3303: IF l_debug_level > 0 THEN
3304: oe_debug_pub.add( 'DELETING HOLD' , 1 ) ;
3305: END IF;
3306: DELETE FROM OE_ORDER_HOLDS
3307: WHERE ORDER_HOLD_ID = l_order_hold_id;
3308:
3309: IF l_debug_level > 0 THEN
3310: oe_debug_pub.add( '(1)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 3379: DELETE FROM OE_ORDER_HOLDS

3375: --ER#7479609 end
3376: IF l_debug_level > 0 THEN
3377: oe_debug_pub.add( 'DELETING HOLD' , 1 ) ;
3378: END IF;
3379: DELETE FROM OE_ORDER_HOLDS
3380: WHERE ORDER_HOLD_ID = l_order_hold_id;
3381:
3382: IF l_debug_level > 0 THEN
3383: oe_debug_pub.add( '(2)L_HOLD_ENTITY_ID/P_HOLD_ENTITY_ID/L_ORDER_HOLD_ID:' || L_HOLD_ENTITY_ID || '/' || P_HOLD_ENTITY_ID || '/' || L_ORDER_HOLD_ID ) ;