DBA Data[Home] [Help]

APPS.CTO_BOM_RTG_PK dependencies on CTO_MSUTIL_PUB

Line 700: cto_msutil_pub.bom_batch_id,effectivity_date,disable_date

696:
697: insert into bom_inventory_comps_interface(component_item_id,bill_sequence_id, batch_id,
698: effectivity_date,disable_date)
699: select component_item_id, bill_sequence_id,
700: cto_msutil_pub.bom_batch_id,effectivity_date,disable_date
701: from bom_inventory_components
702: where bill_sequence_id = lComItmBillId; -- 3543547 lItmBillId;
703:
704: IF PG_DEBUG <> 0 THEN

Line 732: cto_msutil_pub.bom_batch_id,effectivity_date,disable_date

728:
729: insert into bom_inventory_comps_interface(component_item_id,bill_sequence_id, batch_id,
730: effectivity_date,disable_date)
731: select distinct a.base_model_id, b.bill_sequence_id,
732: cto_msutil_pub.bom_batch_id,effectivity_date,disable_date
733: from bom_ato_configurations a,bom_inventory_components b
734: where a.config_item_id = b.component_item_id
735: and b.bill_sequence_id = lComItmBillId; -- 3543547 lItmBillId
736:

Line 1456: and batch_id = cto_msutil_pub.bom_batch_id;

1452:
1453: -- 3543547 Replace lItmBillId with lComItmBillId
1454: delete from bom_inventory_comps_interface
1455: where bill_sequence_id = lComItmBillId
1456: and batch_id = cto_msutil_pub.bom_batch_id;
1457:
1458:
1459: EXCEPTION /* exception for stmt 112 , 115 and 116 */
1460: