DBA Data[Home] [Help]

APPS.CTO_UPDATE_BOM_RTG_PK dependencies on CTO_MSUTIL_PUB

Line 1363: cto_msutil_pub.bom_batch_id

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

Line 1606: cto_msutil_pub.bom_batch_id

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,

Line 2251: cto_msutil_pub.bom_batch_id

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

Line 4086: cto_msutil_pub.bom_batch_id

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

Line 6448: cto_msutil_pub.bom_batch_id

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 ;