DBA Data[Home] [Help]

APPS.CTO_UPDATE_CONFIGS_PK dependencies on BOM_CTO_ORDER_LINES_S1

Line 3103: bom_cto_order_lines_s1.nextval, -- line_id

3099: t_bcol BCOL_TAB;
3100:
3101: CURSOR c_bac_data IS
3102: select
3103: bom_cto_order_lines_s1.nextval, -- line_id
3104: substr(bac.component_code, (instr(bac.component_code, '-', -1)+1)), -- inventory_item_id
3105: bac.component_item_id, -- header_id::storing comp_item_id here for intermediate processing
3106: bac.component_code, -- component_code
3107: msi.bom_item_type, -- bom_item_type

Line 3251: select bom_cto_order_lines_s1.nextval

3247:
3248: -- bug 13362916
3249: IF l_skip_config = 0 then --Bugfix 13362916
3250: l_stmt_num := 50;
3251: select bom_cto_order_lines_s1.nextval
3252: into l_header_id
3253: from dual;
3254:
3255: -- populate top_model_line_id, ato_line_id and header_id

Line 3548: bom_cto_order_lines_s1.nextval, -- line_id

3544:
3545:
3546: CURSOR c_bac_child_data(l_curr_config_id NUMBER) IS
3547: select
3548: bom_cto_order_lines_s1.nextval, -- line_id
3549: substr(bac.component_code, (instr(bac.component_code, '-', -1)+1)), -- inventory_item_id
3550: bac.component_item_id, -- header_id::storing comp_item_id here for intermediate processing
3551: substr(bac.component_code, (instr(bac.component_code, '-', 1)+1)), -- component_code
3552: --bac.config_item_id, -- config_item_id