APPS.CTO_UTILITY_PK dependencies on BOM_CTO_ORDER_LINES_GT

Line 2819: insert into bom_cto_order_lines_gt (

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

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

5753: ,REUSE_CONFIG
5754: ,OPTION_SPECIFIC
5755: ,QTY_PER_PARENT_MODEL
5756: ,CONFIG_CREATION)
5757: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
5758: LINE_ID
5759: ,HEADER_ID
5760: ,TOP_MODEL_LINE_ID
5761: ,LINK_TO_LINE_ID

Line 5790: from bom_cto_order_lines_gt

5786: ,REUSE_CONFIG
5787: ,OPTION_SPECIFIC
5788: ,QTY_PER_PARENT_MODEL
5789: ,CONFIG_CREATION
5790: from bom_cto_order_lines_gt
5791: where ato_line_id = p_ato_line_id ;
5792:
5793: oe_debug_pub.add( ' copied bcol_gt to bcol ' || SQL%ROWCOUNT , 1) ;
5794:

Line 5813: delete from bom_cto_order_lines_gt

5809: begin
5810:
5811: oe_debug_pub.add( ' entered copy bcol to bcol_gt ' , 1) ;
5812: --bugfix#3756670
5813: delete from bom_cto_order_lines_gt
5814: where ato_line_id = p_ato_line_id ;
5815:
5816: insert into bom_cto_order_lines_gt (
5817: LINE_ID

Line 5816: insert into bom_cto_order_lines_gt (

5812: --bugfix#3756670
5813: delete from bom_cto_order_lines_gt
5814: where ato_line_id = p_ato_line_id ;
5815:
5816: insert into bom_cto_order_lines_gt (
5817: LINE_ID
5818: ,HEADER_ID
5819: ,TOP_MODEL_LINE_ID
5820: ,LINK_TO_LINE_ID

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

6921: select nvl(decode(bcolOptions.line_id, bcolModel.line_id, bcolOptions.inventory_item_id,
6922: bcolOptions.config_item_id),
6923: bcolOptions.inventory_item_id) COMPONENT_ITEM_ID
6924: from
6925: bom_cto_order_lines_gt bcolModel, -- Model /* sushant made changes for bug 4341156 */
6926: bom_cto_order_lines_gt bcolOptions -- Options /* sushant made changes for bug 4341156 */
6927: where bcolModel.line_id = p_line_id
6928: and (bcolOptions.parent_ato_line_id = bcolModel.line_id or
6929: bcolOptions.line_id = bcolModel.line_id)

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

6922: bcolOptions.config_item_id),
6923: bcolOptions.inventory_item_id) COMPONENT_ITEM_ID
6924: from
6925: bom_cto_order_lines_gt bcolModel, -- Model /* sushant made changes for bug 4341156 */
6926: bom_cto_order_lines_gt bcolOptions -- Options /* sushant made changes for bug 4341156 */
6927: where bcolModel.line_id = p_line_id
6928: and (bcolOptions.parent_ato_line_id = bcolModel.line_id or
6929: bcolOptions.line_id = bcolModel.line_id)
6930: order by 1;