DBA Data[Home] [Help]

APPS.CTO_CONFIG_BOM_PK dependencies on CTO_MSUTIL_PUB

Line 808: cto_msutil_pub.bom_batch_id

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

Line 1057: cto_msutil_pub.bom_batch_id

1053: 2, --optional_on_model,
1054: ic1.bill_sequence_id, --parent_bill_seq_id,
1055: bcol1.plan_level+1-bcol2.plan_level --plan_level
1056: , nvl(ic1.basis_type,1), /* LBM project */
1057: cto_msutil_pub.bom_batch_id
1058: from
1059: bom_cto_order_lines bcol1, -- component
1060: bom_cto_order_lines bcol2, -- Model
1061: mtl_system_items si1,

Line 2035: cto_msutil_pub.bom_batch_id

2031: 1, --optional_on_model,
2032: 0, --parent_bill_seq_id,
2033: 0 --plan_level
2034: , 1, -- basis_type /* LBM project */
2035: cto_msutil_pub.bom_batch_id
2036: from
2037: bom_cto_order_lines bcol
2038: where bcol.line_id = pLineId
2039: and bcol.ordered_quantity <> 0

Line 2669: cto_msutil_pub.bom_batch_id

2665: parent_bill_seq_id,
2666: plan_level,
2667: revised_item_sequence_id
2668: , nvl(basis_type,1), /* LBM project */
2669: cto_msutil_pub.bom_batch_id
2670: from bom_inventory_comps_interface
2671: where component_item_id = club_comp_rec.item_id
2672: and operation_seq_num = club_comp_rec.operation_seq_num --4244576
2673: and bill_sequence_id = pConfigBillId

Line 4721: cto_msutil_pub.bom_batch_id

4717: plan_level,
4718: top_item_id,
4719: assembly_item_id /* Bug Fix: 4147224 */
4720: , nvl(basis_type,1), /* LBM project */
4721: cto_msutil_pub.bom_batch_id
4722: from bom_explosion_temp
4723: where bill_sequence_id = pConfigBillId;
4724:
4725: lCnt := sql%rowcount ;