APPS.OE_CREDIT_PUB dependencies on OE_ORDER_HOLDS

Line 887: FROM OE_ORDER_HOLDS OH

883: AND decode(H.CREDIT_CARD_APPROVAL_CODE, NULL, (sysdate -1),
884: (H.CREDIT_CARD_APPROVAL_DATE + l_est_valid_days)) < sysdate
885: */
886: AND EXISTS (SELECT 1
887: FROM OE_ORDER_HOLDS OH
888: WHERE H.HEADER_ID = OH.HEADER_ID
889: AND OH.HOLD_RELEASE_ID IS NULL
890: );
891:

Line 958: FROM OE_ORDER_HOLDS OH

954: AND L.LINE_CATEGORY_CODE = 'ORDER'
955: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,H.REQUEST_DATE))
956: <= l_shipping_horizon
957: AND EXISTS (SELECT 'Hold Exists'
958: FROM OE_ORDER_HOLDS OH
959: WHERE H.HEADER_ID = OH.HEADER_ID
960: AND OH.HOLD_RELEASE_ID IS NULL );
961:
962: Cursor current_commitment_total IS

Line 1107: FROM OE_ORDER_HOLDS OH

1103: And effective_auth_amount > 0)
1104: )
1105: )
1106: AND EXISTS (SELECT 1
1107: FROM OE_ORDER_HOLDS OH
1108: WHERE H.HEADER_ID = OH.HEADER_ID
1109: AND OH.HOLD_RELEASE_ID IS NULL
1110: );
1111:

Line 1177: FROM OE_ORDER_HOLDS OH

1173: AND H.HEADER_ID <> p_header_rec.header_id
1174: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,H.REQUEST_DATE))
1175: <= l_shipping_horizon
1176: AND EXISTS (SELECT 'Hold Exists'
1177: FROM OE_ORDER_HOLDS OH
1178: WHERE H.HEADER_ID = OH.HEADER_ID
1179: AND OH.HOLD_RELEASE_ID IS NULL );
1180:
1181: /* additional task- Current Order - */

Line 2564: FROM OE_ORDER_HOLDS OH

2560: And effective_auth_amount > 0)
2561: )
2562: )
2563: AND EXISTS (SELECT 1
2564: FROM OE_ORDER_HOLDS OH
2565: WHERE H.HEADER_ID = OH.HEADER_ID
2566: AND OH.HOLD_RELEASE_ID IS NULL
2567: );
2568: Cursor commitment_total IS

Line 2632: FROM OE_ORDER_HOLDS OH

2628: AND L.LINE_CATEGORY_CODE = 'ORDER'
2629: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,H.REQUEST_DATE))
2630: <= l_shipping_horizon
2631: AND EXISTS (SELECT 1
2632: FROM OE_ORDER_HOLDS OH
2633: WHERE H.HEADER_ID = OH.HEADER_ID
2634: AND OH.HOLD_RELEASE_ID IS NULL);
2635:
2636: Cursor current_commitment_total IS

Line 2809: FROM OE_ORDER_HOLDS OH

2805: And effective_auth_amount > 0)
2806: )
2807: )
2808: AND EXISTS (SELECT 1
2809: FROM OE_ORDER_HOLDS OH
2810: WHERE H.HEADER_ID = OH.HEADER_ID
2811: AND OH.HOLD_RELEASE_ID IS NULL
2812: );
2813:

Line 2877: FROM OE_ORDER_HOLDS OH

2873: And effective_auth_amount > 0)
2874: )
2875: )
2876: AND EXISTS (SELECT 1
2877: FROM OE_ORDER_HOLDS OH
2878: WHERE H.HEADER_ID = OH.HEADER_ID
2879: AND OH.HOLD_RELEASE_ID IS NULL);
2880:
2881: /* additional task- Current Order - */