DBA Data[Home] [Help]

APPS.CTO_CONFIG_BOM_PK dependencies on CTO_MSUTIL_PUB

Line 810: cto_msutil_pub.bom_batch_id

806: (bcol1.plan_level-bcol2.plan_level) --plan_level
807: ,bcol1.line_id /* 2524562 Storing line_id */
808: ,bcol3.inventory_item_id /* Bug fix: 4863055 */
809: , nvl(ic1.basis_type,1), /* LBM project */
810: cto_msutil_pub.bom_batch_id
811: from
812: bom_inventory_components ic1,
813: bom_cto_order_lines bcol1, --Option
814: bom_cto_order_lines bcol2, -- Parent-Model

Line 1082: cto_msutil_pub.bom_batch_id

1078: 2, --optional_on_model,
1079: ic1.bill_sequence_id, --parent_bill_seq_id,
1080: bcol1.plan_level+1-bcol2.plan_level --plan_level
1081: , nvl(ic1.basis_type,1), /* LBM project */
1082: cto_msutil_pub.bom_batch_id
1083: from
1084: bom_cto_order_lines bcol1, -- component
1085: bom_cto_order_lines bcol2, -- Model
1086: mtl_system_items si1,

Line 2061: cto_msutil_pub.bom_batch_id

2057: 1, --optional_on_model,
2058: 0, --parent_bill_seq_id,
2059: 0 --plan_level
2060: , 1, -- basis_type /* LBM project */
2061: cto_msutil_pub.bom_batch_id
2062: from
2063: bom_cto_order_lines bcol
2064: where bcol.line_id = pLineId
2065: and bcol.ordered_quantity <> 0

Line 2729: cto_msutil_pub.bom_batch_id

2725: parent_bill_seq_id,
2726: plan_level,
2727: revised_item_sequence_id
2728: , nvl(basis_type,1), /* LBM project */
2729: cto_msutil_pub.bom_batch_id
2730: from bom_inventory_comps_interface
2731: where component_item_id = club_comp_rec.item_id
2732: and operation_seq_num = club_comp_rec.operation_seq_num --4244576
2733: and bill_sequence_id = pConfigBillId

Line 5048: cto_msutil_pub.bom_batch_id

5044: plan_level,
5045: top_item_id,
5046: assembly_item_id /* Bug Fix: 4147224 */
5047: , nvl(basis_type,1), /* LBM project */
5048: cto_msutil_pub.bom_batch_id
5049: from bom_explosion_temp
5050: where bill_sequence_id = pConfigBillId;
5051:
5052: lCnt := sql%rowcount ;