APPS.CTO_OSS_SOURCE_PK dependencies on BOM_CTO_ORDER_LINES_UPG

Line 690: update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_UPG_N4) */ bom_cto_order_lines_upg bcol

686: from bom_cto_order_lines_gt bcol_gt
687: where bcol_gt.line_id = bcol.line_id)
688: where bcol.ato_line_id = p_ato_line_id;
689: elsif p_mode = 'UPG' then
690: update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_UPG_N4) */ bom_cto_order_lines_upg bcol
691: set option_specific = (select /*+ INDEX (bcol_gt BOM_CTO_ORDER_LINES_GT_U1) */
692: decode(option_specific,'4','3',option_specific)
693: from bom_cto_order_lines_gt bcol_gt
694: where bcol_gt.line_id = bcol.line_id)

Line 1795: from bom_cto_order_lines_upg

1791: option_specific,
1792: config_creation,
1793: perform_match,
1794: reuse_config
1795: from bom_cto_order_lines_upg
1796: where ato_line_id = p_Ato_line_id
1797: and option_specific in ('1','2','3')
1798: and p_mode = 'UPG'
1799: and (p_changed_src = 'Y' or config_creation=3);

Line 2889: from bom_cto_order_lines_upg bcol

2885: If p_mode = 'UPG' then
2886:
2887: update mtl_system_items msi
2888: set msi.option_specific_sourced = (select bcol.option_specific
2889: from bom_cto_order_lines_upg bcol
2890: where bcol.ato_line_id= p_ato_line_id
2891: and bcol.config_item_id = msi.inventory_item_id
2892: )
2893: where msi.inventory_item_id in (select config_item_id

Line 2894: from bom_cto_order_lines_upg

2890: where bcol.ato_line_id= p_ato_line_id
2891: and bcol.config_item_id = msi.inventory_item_id
2892: )
2893: where msi.inventory_item_id in (select config_item_id
2894: from bom_cto_order_lines_upg
2895: where ato_line_id = p_ato_line_id
2896: and bom_item_type = 1
2897: and option_specific in ('1','2','3')
2898: );

Line 5139: Select /*+ INDEX (bcol_upg BOM_CTO_ORDER_LINES_UPG_N4) */

5135: REUSE_CONFIG,
5136: QTY_PER_PARENT_MODEL,
5137: CONFIG_CREATION
5138: )
5139: Select /*+ INDEX (bcol_upg BOM_CTO_ORDER_LINES_UPG_N4) */
5140: ATO_LINE_ID,
5141: BATCH_ID,
5142: BOM_ITEM_TYPE,
5143: COMPONENT_CODE,

Line 5165: from bom_cto_order_lines_upg bcol_upg

5161: REUSE_CONFIG,
5162: QTY_PER_PARENT_MODEL,
5163: CONFIG_CREATION
5164:
5165: from bom_cto_order_lines_upg bcol_upg
5166: where ato_line_id = p_ato_line_id;
5167:
5168:
5169: If PG_DEBUG <> 0 Then