DBA Data[Home] [Help]

APPS.CTO_UPDATE_BOM_RTG_PK dependencies on CTO_MSUTIL_PUB

Line 1422: cto_msutil_pub.bom_batch_id

1418: (bcol1.plan_level-bcol2.plan_level), --plan_level
1419: bcol1.line_id,
1420: bcol3.inventory_item_id /* Bug Fix: 4147224 */
1421: , nvl(ic1.basis_type,1), /* LBM project */
1422: cto_msutil_pub.bom_batch_id
1423: from
1424: bom_inventory_components ic1,
1425: bom_cto_order_lines_upg bcol1, -- Option
1426: bom_cto_order_lines_upg bcol2, -- Parent-Model

Line 1665: cto_msutil_pub.bom_batch_id

1661: 2, --optional_on_model,
1662: ic1.bill_sequence_id, --parent_bill_seq_id,
1663: bcol1.plan_level+1-bcol2.plan_level --plan_level
1664: , nvl(ic1.basis_type,1), /* LBM project */
1665: cto_msutil_pub.bom_batch_id
1666: from
1667: bom_cto_order_lines_upg bcol1, -- component
1668: bom_cto_order_lines_upg bcol2, -- Model
1669: mtl_system_items si1,

Line 2340: cto_msutil_pub.bom_batch_id

2336: 1, --optional_on_model,
2337: 0, --parent_bill_seq_id,
2338: 0 --plan_level
2339: , 1, -- basis_type /* LBM project */
2340: cto_msutil_pub.bom_batch_id
2341: from
2342: bom_cto_order_lines_upg bcol
2343: where bcol.line_id = pLineId
2344: and bcol.ordered_quantity <> 0

Line 4253: cto_msutil_pub.bom_batch_id

4249: parent_bill_seq_id,
4250: plan_level,
4251: revised_item_sequence_id
4252: , nvl(basis_type,1), /* LBM project */
4253: cto_msutil_pub.bom_batch_id
4254: from bom_inventory_comps_interface
4255: where component_item_id = club_comp_rec.item_id
4256: and operation_seq_num = club_comp_rec.operation_seq_num --4244576
4257: and bill_sequence_id = lConfigBillId

Line 6660: cto_msutil_pub.bom_batch_id

6656: plan_level,
6657: top_item_id,
6658: assembly_item_id /* Bug Fix: 4147224 */
6659: , nvl(basis_type,1), /* LBM project */
6660: cto_msutil_pub.bom_batch_id
6661: from bom_explosion_temp
6662: where bill_sequence_id = pConfigBillId;
6663:
6664: lCnt := sql%rowcount ;