APPS.CTO_UTILITY_PK dependencies on BOM_CTO_ORDER_LINES_GT

Line 2821: insert into bom_cto_order_lines_gt (

2817:
2818: else
2819:
2820:
2821: insert into bom_cto_order_lines_gt (
2822: LINE_ID
2823: ,HEADER_ID
2824: ,TOP_MODEL_LINE_ID
2825: ,LINK_TO_LINE_ID

Line 5781: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */

5777: ,REUSE_CONFIG
5778: ,OPTION_SPECIFIC
5779: ,QTY_PER_PARENT_MODEL
5780: ,CONFIG_CREATION)
5781: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
5782: LINE_ID
5783: ,HEADER_ID
5784: ,TOP_MODEL_LINE_ID
5785: ,LINK_TO_LINE_ID

Line 5814: from bom_cto_order_lines_gt

5810: ,REUSE_CONFIG
5811: ,OPTION_SPECIFIC
5812: ,QTY_PER_PARENT_MODEL
5813: ,CONFIG_CREATION
5814: from bom_cto_order_lines_gt
5815: where ato_line_id = p_ato_line_id ;
5816:
5817: oe_debug_pub.add( ' copied bcol_gt to bcol ' || SQL%ROWCOUNT , 1) ;
5818:

Line 5837: delete from bom_cto_order_lines_gt

5833: begin
5834:
5835: oe_debug_pub.add( ' entered copy bcol to bcol_gt ' , 1) ;
5836: --bugfix#3756670
5837: delete from bom_cto_order_lines_gt
5838: where ato_line_id = p_ato_line_id ;
5839:
5840: insert into bom_cto_order_lines_gt (
5841: LINE_ID

Line 5840: insert into bom_cto_order_lines_gt (

5836: --bugfix#3756670
5837: delete from bom_cto_order_lines_gt
5838: where ato_line_id = p_ato_line_id ;
5839:
5840: insert into bom_cto_order_lines_gt (
5841: LINE_ID
5842: ,HEADER_ID
5843: ,TOP_MODEL_LINE_ID
5844: ,LINK_TO_LINE_ID

Line 6949: bom_cto_order_lines_gt bcolModel, -- Model /* sushant made changes for bug 4341156 */

6945: select nvl(decode(bcolOptions.line_id, bcolModel.line_id, bcolOptions.inventory_item_id,
6946: bcolOptions.config_item_id),
6947: bcolOptions.inventory_item_id) COMPONENT_ITEM_ID
6948: from
6949: bom_cto_order_lines_gt bcolModel, -- Model /* sushant made changes for bug 4341156 */
6950: bom_cto_order_lines_gt bcolOptions -- Options /* sushant made changes for bug 4341156 */
6951: where bcolModel.line_id = p_line_id
6952: and (bcolOptions.parent_ato_line_id = bcolModel.line_id or
6953: bcolOptions.line_id = bcolModel.line_id)

Line 6950: bom_cto_order_lines_gt bcolOptions -- Options /* sushant made changes for bug 4341156 */

6946: bcolOptions.config_item_id),
6947: bcolOptions.inventory_item_id) COMPONENT_ITEM_ID
6948: from
6949: bom_cto_order_lines_gt bcolModel, -- Model /* sushant made changes for bug 4341156 */
6950: bom_cto_order_lines_gt bcolOptions -- Options /* sushant made changes for bug 4341156 */
6951: where bcolModel.line_id = p_line_id
6952: and (bcolOptions.parent_ato_line_id = bcolModel.line_id or
6953: bcolOptions.line_id = bcolModel.line_id)
6954: order by 1;