1359: (bcol1.plan_level-bcol2.plan_level), --plan_level
1360: bcol1.line_id,
1361: bcol3.inventory_item_id /* Bug Fix: 4147224 */
1362: , nvl(ic1.basis_type,1), /* LBM project */
1363: cto_msutil_pub.bom_batch_id
1364: from
1365: bom_inventory_components ic1,
1366: bom_cto_order_lines_upg bcol1, -- Option
1367: bom_cto_order_lines_upg bcol2, -- Parent-Model
1602: 2, --optional_on_model,
1603: ic1.bill_sequence_id, --parent_bill_seq_id,
1604: bcol1.plan_level+1-bcol2.plan_level --plan_level
1605: , nvl(ic1.basis_type,1), /* LBM project */
1606: cto_msutil_pub.bom_batch_id
1607: from
1608: bom_cto_order_lines_upg bcol1, -- component
1609: bom_cto_order_lines_upg bcol2, -- Model
1610: mtl_system_items si1,
2247: 1, --optional_on_model,
2248: 0, --parent_bill_seq_id,
2249: 0 --plan_level
2250: , 1, -- basis_type /* LBM project */
2251: cto_msutil_pub.bom_batch_id
2252: from
2253: bom_cto_order_lines_upg bcol
2254: where bcol.line_id = pLineId
2255: and bcol.ordered_quantity <> 0
4082: parent_bill_seq_id,
4083: plan_level,
4084: revised_item_sequence_id
4085: , nvl(basis_type,1), /* LBM project */
4086: cto_msutil_pub.bom_batch_id
4087: from bom_inventory_comps_interface
4088: where component_item_id = club_comp_rec.item_id
4089: and operation_seq_num = club_comp_rec.operation_seq_num --4244576
4090: and bill_sequence_id = lConfigBillId
6444: plan_level,
6445: top_item_id,
6446: assembly_item_id /* Bug Fix: 4147224 */
6447: , nvl(basis_type,1), /* LBM project */
6448: cto_msutil_pub.bom_batch_id
6449: from bom_explosion_temp
6450: where bill_sequence_id = pConfigBillId;
6451:
6452: lCnt := sql%rowcount ;