APPS.ECE_SPSO_TRANS2 dependencies on CHV_ITEM_ORDERS

Line 38: AND EXISTS (SELECT 1 FROM CHV_ITEM_ORDERS CIO

34: PO_VENDOR_SITES PVS,
35: CHV_SCHEDULE_HEADERS CSH
36: WHERE
37: CSH.SCHEDULE_STATUS = 'CONFIRMED'
38: AND EXISTS (SELECT 1 FROM CHV_ITEM_ORDERS CIO
39: WHERE CIO.SCHEDULE_ID = CSH.SCHEDULE_ID)
40: AND ETD.EDI_FLAG = 'Y' -- EDI
41: AND ETD.DOCUMENT_ID = P_TRANSACTION_TYPE --ship SSSO,plan SPSO
42: AND P_TRANSACTION_TYPE = DECODE(SCHEDULE_TYPE, 'SHIP_SCHEDULE',

Line 112: AND EXISTS (SELECT 1 FROM CHV_ITEM_ORDERS CIO

108: FROM
109: CHV_SCHEDULE_ITEMS CSI
110: WHERE
111: CSI.SCHEDULE_ID = REC_HDR.SCHEDULE_ID
112: AND EXISTS (SELECT 1 FROM CHV_ITEM_ORDERS CIO
113: WHERE CIO.SCHEDULE_ID = CSI.SCHEDULE_ID);
114:
115: BEGIN -- begin item block
116: <>

Line 120: From chv_item_orders

116: <>
117: xProgress := 'SPSO2B-10-1020';
118: Select count(*)
119: Into x_item_order
120: From chv_item_orders
121: Where schedule_id = rec_hdr.schedule_id;
122: -- 2944455
123: fnd_profile.get('ECE_SPSO_EXCLUDE_ZERO_SCHEDULE_FROM_FF',exclude_zero_schedule_from_ff);
124: If NVL(exclude_zero_schedule_from_ff,'N')<>'Y' then

Line 140: From chv_item_orders

136:
137: xProgress := 'SPSO2B-10-1030';
138: Select count(schedule_id)
139: Into x_item_detail
140: From chv_item_orders
141: Where schedule_id = rec_hdr.schedule_id
142: And schedule_item_id = rec_item.schedule_item_id;
143: -- 2944455
144: IF ((exclude_zero_schedule_from_ff = 'N') OR

Line 1243: FROM CHV_ITEM_ORDERS CIO, PO_LINE_LOCATIONS POLL,

1239: HRL.TELEPHONE_NUMBER_1 ITEM_DET_ST_PHONE,
1240: POH.SEGMENT1||'-'||to_char(POR.RELEASE_NUM) DOCUMENT_RELEASE_NUMBER,
1241: POL.LINE_NUM DOCUMENT_LINE_NUMBER,
1242: POLL.LINE_LOCATION_ID LINE_LOCATION_ID
1243: FROM CHV_ITEM_ORDERS CIO, PO_LINE_LOCATIONS POLL,
1244: HR_LOCATIONS HRL, MTL_UNITS_OF_MEASURE MUM,
1245: PO_HEADERS POH, PO_LINES POL, PO_RELEASES POR
1246: WHERE CIO.SCHEDULE_ID = rec_item.schedule_id
1247: AND CIO.SCHEDULE_ITEM_ID = rec_item.schedule_item_id