APPS.ECE_SPSO_TRANS2 dependencies on CHV_ITEM_ORDERS

Line 40: -- AND EXISTS (SELECT 1 FROM CHV_ITEM_ORDERS CIO

36: WHERE
37: CSH.SCHEDULE_STATUS = 'CONFIRMED'
38: --bug11893659 We ll be printing the item record (2000th) and the item details record (4000th)
39: --even if the item does not have future requirements.
40: -- AND EXISTS (SELECT 1 FROM CHV_ITEM_ORDERS CIO
41: -- WHERE CIO.SCHEDULE_ID = CSH.SCHEDULE_ID)
42: AND ETD.EDI_FLAG = 'Y' -- EDI
43: AND ETD.DOCUMENT_ID = P_TRANSACTION_TYPE --ship SSSO,plan SPSO
44: AND P_TRANSACTION_TYPE = DECODE(SCHEDULE_TYPE, 'SHIP_SCHEDULE',

Line 119: -- AND EXISTS (SELECT 1 FROM CHV_ITEM_ORDERS CIO

115: WHERE
116: CSI.SCHEDULE_ID = REC_HDR.SCHEDULE_ID;
117: --bug11893659 We ll be printing the item record (2000th) and the item details record (4000th)
118: --even if the item does not have future requirements.
119: -- AND EXISTS (SELECT 1 FROM CHV_ITEM_ORDERS CIO
120: -- WHERE CIO.SCHEDULE_ID = CSI.SCHEDULE_ID);
121:
122: BEGIN -- begin item block
123: <>

Line 129: From chv_item_orders

125: --bug12422231 Uncommented to tackle the case when profile is 'Y'
126: --(regression from 11893659)
127: Select count(*)
128: Into x_item_order
129: From chv_item_orders
130: Where schedule_id = rec_hdr.schedule_id;
131: -- 2944455
132: fnd_profile.get('ECE_SPSO_EXCLUDE_ZERO_SCHEDULE_FROM_FF',exclude_zero_schedule_from_ff);
133: If NVL(exclude_zero_schedule_from_ff,'N')<>'Y' then

Line 155: From chv_item_orders

151: --bug12422231 Uncommented to tackle the case when profile is 'Y'
152: --(regression from 11893659)
153: Select count(schedule_id)
154: Into x_item_detail
155: From chv_item_orders
156: Where schedule_id = rec_hdr.schedule_id
157: And schedule_item_id = rec_item.schedule_item_id;
158: -- 2944455
159: IF ((exclude_zero_schedule_from_ff = 'N')

Line 1264: FROM CHV_ITEM_ORDERS CIO, PO_LINE_LOCATIONS POLL,

1260: POH.SEGMENT1||'-'||to_char(POR.RELEASE_NUM) DOCUMENT_RELEASE_NUMBER,
1261: POL.LINE_NUM DOCUMENT_LINE_NUMBER,
1262: POLL.LINE_LOCATION_ID LINE_LOCATION_ID,
1263: POLL.QUANTITY_RECEIVED QUANTITY_RECEIVED --
1264: FROM CHV_ITEM_ORDERS CIO, PO_LINE_LOCATIONS POLL,
1265: HR_LOCATIONS HRL, MTL_UNITS_OF_MEASURE MUM,
1266: PO_HEADERS POH, PO_LINES POL, PO_RELEASES POR
1267: WHERE CIO.SCHEDULE_ID = rec_item.schedule_id
1268: AND CIO.SCHEDULE_ITEM_ID = rec_item.schedule_item_id