APPS.OE_CREDIT_PUB dependencies on OE_ORDER_HOLDS

Line 869: FROM OE_ORDER_HOLDS OH

865: AND decode(H.CREDIT_CARD_APPROVAL_CODE, NULL, (sysdate -1),
866: (H.CREDIT_CARD_APPROVAL_DATE + l_est_valid_days)) < sysdate
867: */
868: AND EXISTS (SELECT 1
869: FROM OE_ORDER_HOLDS OH
870: WHERE H.HEADER_ID = OH.HEADER_ID
871: AND OH.HOLD_RELEASE_ID IS NULL
872: );
873:

Line 940: FROM OE_ORDER_HOLDS OH

936: AND L.LINE_CATEGORY_CODE = 'ORDER'
937: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,H.REQUEST_DATE))
938: <= l_shipping_horizon
939: AND EXISTS (SELECT 'Hold Exists'
940: FROM OE_ORDER_HOLDS OH
941: WHERE H.HEADER_ID = OH.HEADER_ID
942: AND OH.HOLD_RELEASE_ID IS NULL );
943:
944: Cursor current_commitment_total IS

Line 1089: FROM OE_ORDER_HOLDS OH

1085: And effective_auth_amount > 0)
1086: )
1087: )
1088: AND EXISTS (SELECT 1
1089: FROM OE_ORDER_HOLDS OH
1090: WHERE H.HEADER_ID = OH.HEADER_ID
1091: AND OH.HOLD_RELEASE_ID IS NULL
1092: );
1093:

Line 1159: FROM OE_ORDER_HOLDS OH

1155: AND H.HEADER_ID <> p_header_rec.header_id
1156: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,H.REQUEST_DATE))
1157: <= l_shipping_horizon
1158: AND EXISTS (SELECT 'Hold Exists'
1159: FROM OE_ORDER_HOLDS OH
1160: WHERE H.HEADER_ID = OH.HEADER_ID
1161: AND OH.HOLD_RELEASE_ID IS NULL );
1162:
1163: /* additional task- Current Order - */

Line 2528: FROM OE_ORDER_HOLDS OH

2524: And effective_auth_amount > 0)
2525: )
2526: )
2527: AND EXISTS (SELECT 1
2528: FROM OE_ORDER_HOLDS OH
2529: WHERE H.HEADER_ID = OH.HEADER_ID
2530: AND OH.HOLD_RELEASE_ID IS NULL
2531: );
2532: Cursor commitment_total IS

Line 2596: FROM OE_ORDER_HOLDS OH

2592: AND L.LINE_CATEGORY_CODE = 'ORDER'
2593: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,H.REQUEST_DATE))
2594: <= l_shipping_horizon
2595: AND EXISTS (SELECT 1
2596: FROM OE_ORDER_HOLDS OH
2597: WHERE H.HEADER_ID = OH.HEADER_ID
2598: AND OH.HOLD_RELEASE_ID IS NULL);
2599:
2600: Cursor current_commitment_total IS

Line 2773: FROM OE_ORDER_HOLDS OH

2769: And effective_auth_amount > 0)
2770: )
2771: )
2772: AND EXISTS (SELECT 1
2773: FROM OE_ORDER_HOLDS OH
2774: WHERE H.HEADER_ID = OH.HEADER_ID
2775: AND OH.HOLD_RELEASE_ID IS NULL
2776: );
2777:

Line 2841: FROM OE_ORDER_HOLDS OH

2837: And effective_auth_amount > 0)
2838: )
2839: )
2840: AND EXISTS (SELECT 1
2841: FROM OE_ORDER_HOLDS OH
2842: WHERE H.HEADER_ID = OH.HEADER_ID
2843: AND OH.HOLD_RELEASE_ID IS NULL);
2844:
2845: /* additional task- Current Order - */