APPS.CTO_OSS_SOURCE_PK dependencies on BOM_CTO_ORDER_LINES_UPG

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

755: from bom_cto_order_lines_gt bcol_gt
756: where bcol_gt.line_id = bcol.line_id)
757: where bcol.ato_line_id = p_ato_line_id;
758: elsif p_mode = 'UPG' then
759: update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_UPG_N4) */ bom_cto_order_lines_upg bcol
760: set option_specific = (select /*+ INDEX (bcol_gt BOM_CTO_ORDER_LINES_GT_U1) */
761: decode(option_specific,'4','3',option_specific)
762: from bom_cto_order_lines_gt bcol_gt
763: where bcol_gt.line_id = bcol.line_id)

Line 1942: from bom_cto_order_lines_upg

1938: option_specific,
1939: config_creation,
1940: perform_match,
1941: reuse_config
1942: from bom_cto_order_lines_upg
1943: where ato_line_id = p_Ato_line_id
1944: and option_specific in ('1','2','3')
1945: and p_mode = 'UPG'
1946: and (p_changed_src = 'Y' or config_creation=3);

Line 3324: from bom_cto_order_lines_upg bcol

3320: If p_mode = 'UPG' then
3321:
3322: update mtl_system_items msi
3323: set msi.option_specific_sourced = (select bcol.option_specific
3324: from bom_cto_order_lines_upg bcol
3325: where bcol.ato_line_id= p_ato_line_id
3326: and bcol.config_item_id = msi.inventory_item_id
3327: )
3328: --Bugfix 12917456: Adding a distinct. This sql otherwise returns ORA-01427 error

Line 3332: from bom_cto_order_lines_upg

3328: --Bugfix 12917456: Adding a distinct. This sql otherwise returns ORA-01427 error
3329: --when a top level config has the same child config appearing in its BOM multiple
3330: --times.
3331: where msi.inventory_item_id in (select distinct config_item_id
3332: from bom_cto_order_lines_upg
3333: where ato_line_id = p_ato_line_id
3334: and bom_item_type = 1
3335: and option_specific in ('1','2','3')
3336: );

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

5798: QTY_PER_PARENT_MODEL,
5799: CONFIG_CREATION,
5800: program_id --Bugfix 8894392
5801: )
5802: Select /*+ INDEX (bcol_upg BOM_CTO_ORDER_LINES_UPG_N4) */
5803: ATO_LINE_ID,
5804: BATCH_ID,
5805: BOM_ITEM_TYPE,
5806: COMPONENT_CODE,

Line 5829: from bom_cto_order_lines_upg bcol_upg

5825: QTY_PER_PARENT_MODEL,
5826: CONFIG_CREATION,
5827: program_id --Bugfix 8894392
5828:
5829: from bom_cto_order_lines_upg bcol_upg
5830: where ato_line_id = p_ato_line_id;
5831:
5832:
5833: If PG_DEBUG <> 0 Then