eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_AUTO_DROPSHIP_PK dependencies on BOM_CTO_ORDER_LINES_TEMP

Line 191: NOTE: We are doing a insert into bom_cto_order_lines_temp select .... using dyanamic sql

187: l_organization_id := p_organization_id;
188:
189: /******************Begin Bugfix 4384668 ***************************************/
190: /*
191: NOTE: We are doing a insert into bom_cto_order_lines_temp select .... using dyanamic sql
192: followed by a select ...bulk collect... from bom_cto_order_lines_temp. A more efficient
193: approach would be to do a direct select..bulk collect.. from oe_order_lines...
194: in the dyanamic sql instead of going via the GTT. However bulk collect with dyanamic sql
195: is supported 9i onwards. For 11.5.9, we need to make it compatible with 8i database as well.

Line 192: followed by a select ...bulk collect... from bom_cto_order_lines_temp. A more efficient

188:
189: /******************Begin Bugfix 4384668 ***************************************/
190: /*
191: NOTE: We are doing a insert into bom_cto_order_lines_temp select .... using dyanamic sql
192: followed by a select ...bulk collect... from bom_cto_order_lines_temp. A more efficient
193: approach would be to do a direct select..bulk collect.. from oe_order_lines...
194: in the dyanamic sql instead of going via the GTT. However bulk collect with dyanamic sql
195: is supported 9i onwards. For 11.5.9, we need to make it compatible with 8i database as well.
196: This restriction may not be there in R12. Please keep this in mind while front porting.

Line 199: delete from bom_cto_order_lines_temp;

195: is supported 9i onwards. For 11.5.9, we need to make it compatible with 8i database as well.
196: This restriction may not be there in R12. Please keep this in mind while front porting.
197: */
198:
199: delete from bom_cto_order_lines_temp;
200:
201: drive_mark := 0;
202: sql_stmt := 'INSERT INTO bom_cto_order_lines_temp (line_id, org_id, ship_from_org_id, schedule_ship_date, inventory_item_id) '||
203: 'SELECT oel.line_id, oel.org_id, oel.ship_from_org_id, oel.schedule_ship_date, 1 '||

Line 202: sql_stmt := 'INSERT INTO bom_cto_order_lines_temp (line_id, org_id, ship_from_org_id, schedule_ship_date, inventory_item_id) '||

198:
199: delete from bom_cto_order_lines_temp;
200:
201: drive_mark := 0;
202: sql_stmt := 'INSERT INTO bom_cto_order_lines_temp (line_id, org_id, ship_from_org_id, schedule_ship_date, inventory_item_id) '||
203: 'SELECT oel.line_id, oel.org_id, oel.ship_from_org_id, oel.schedule_ship_date, 1 '||
204: 'from oe_order_lines_all oel, '||
205: ' mtl_system_items msi, '||
206: ' wf_item_activity_statuses was, '||

Line 396: from bom_cto_order_lines_temp;

392: end if;
393:
394: select line_id, org_id, ship_from_org_id, schedule_ship_date
395: BULK COLLECT INTO line_id_arr, org_id_arr, ship_from_org_id_arr, schedule_ship_date_arr
396: from bom_cto_order_lines_temp;
397: i := line_id_arr.first;
398: WHILE i is not null
399: /*
400: -- Open loop for selecting all the eligible lines.