APPS.ECE_SPSO_TRANS1 dependencies on CHV_ITEM_ORDERS

Line 1209: chv_item_orders where

1205: xProgress := 'SPSOB-10-1431';
1206: begin
1207: select count(*) into
1208: x_schedule_order from
1209: chv_item_orders where
1210: schedule_id = l_header_tbl(n_schedule_id_pos).value;
1211: exception
1212: when others then
1213: null;

Line 1542: From chv_item_orders

1538: xProgress := 'SPSOB-10-1551';
1539: Begin
1540: Select count(schedule_id)
1541: Into x_item_detail
1542: From chv_item_orders
1543: Where schedule_id = l_header_tbl(n_schedule_id_pos).value
1544: And schedule_item_id = l_item_tbl(n_item_id_pos).value;
1545: Exception
1546: when others then null;

Line 1810: AND EXISTS (SELECT 1 FROM CHV_ITEM_ORDERS CIO

1806: )
1807: )
1808: )
1809: )
1810: AND EXISTS (SELECT 1 FROM CHV_ITEM_ORDERS CIO
1811: WHERE CIO.SCHEDULE_ID = CSH.SCHEDULE_ID)
1812: ORDER BY
1813: csh.schedule_id
1814: FOR UPDATE;

Line 1903: AND EXISTS (SELECT 1 FROM CHV_ITEM_ORDERS CIO

1899: )
1900: )
1901: )
1902: )
1903: AND EXISTS (SELECT 1 FROM CHV_ITEM_ORDERS CIO
1904: WHERE CIO.SCHEDULE_ITEM_ID = CSI.SCHEDULE_ITEM_ID)
1905: ORDER BY
1906: csi.schedule_id,
1907: csi.schedule_item_id,

Line 2038: From chv_item_orders

2034: rec_hdr.batch_id, --Bug 2064311
2035: rec_hdr.edi_count );
2036: Select count(*)
2037: Into x_item_order
2038: From chv_item_orders
2039: Where schedule_id = rec_hdr.schedule_id;
2040:
2041: Select count(schedule_id)
2042: Into x_item_detail

Line 2043: From chv_item_orders

2039: Where schedule_id = rec_hdr.schedule_id;
2040:
2041: Select count(schedule_id)
2042: Into x_item_detail
2043: From chv_item_orders
2044: Where schedule_id = rec_hdr.schedule_id
2045: And schedule_item_id = rec_item.schedule_item_id;
2046:
2047: fnd_profile.get('ECE_SPSO_EXCLUDE_ZERO_SCHEDULE_FROM_FF',exclude_zero_schedule_from_ff);