DBA Data[Home] [Help]

APPS.CTO_UPDATE_CONFIGS_PK dependencies on BOM_CTO_ORDER_LINES_S1

Line 2871: bom_cto_order_lines_s1.nextval, -- line_id

2867: t_bcol BCOL_TAB;
2868:
2869: CURSOR c_bac_data IS
2870: select
2871: bom_cto_order_lines_s1.nextval, -- line_id
2872: substr(bac.component_code, (instr(bac.component_code, '-', -1)+1)), -- inventory_item_id
2873: bac.component_item_id, -- header_id::storing comp_item_id here for intermediate processing
2874: bac.component_code, -- component_code
2875: msi.bom_item_type, -- bom_item_type

Line 3001: select bom_cto_order_lines_s1.nextval

2997: END IF;
2998: END LOOP;
2999:
3000: l_stmt_num := 50;
3001: select bom_cto_order_lines_s1.nextval
3002: into l_header_id
3003: from dual;
3004:
3005: -- populate top_model_line_id, ato_line_id and header_id

Line 3181: bom_cto_order_lines_s1.nextval, -- line_id

3177:
3178:
3179: CURSOR c_bac_child_data(l_curr_config_id NUMBER) IS
3180: select
3181: bom_cto_order_lines_s1.nextval, -- line_id
3182: substr(bac.component_code, (instr(bac.component_code, '-', -1)+1)), -- inventory_item_id
3183: bac.component_item_id, -- header_id::storing comp_item_id here for intermediate processing
3184: substr(bac.component_code, (instr(bac.component_code, '-', 1)+1)), -- component_code
3185: --bac.config_item_id, -- config_item_id