DBA Data[Home] [Help]

APPS.CTO_BOM_RTG_PK dependencies on BOM_INVENTORY_COMPONENTS

Line 704: from bom_inventory_components

700: insert into bom_inventory_comps_interface(component_item_id,bill_sequence_id, batch_id,
701: effectivity_date,disable_date)
702: select component_item_id, bill_sequence_id,
703: cto_msutil_pub.bom_batch_id,effectivity_date,disable_date
704: from bom_inventory_components
705: where bill_sequence_id = lComItmBillId; -- 3543547 lItmBillId;
706:
707: IF PG_DEBUG <> 0 THEN
708: oe_debug_pub.add('Value of gMatch '||CTO_MATCH_CONFIG.gMatch ,1);

Line 736: from bom_ato_configurations a,bom_inventory_components b

732: insert into bom_inventory_comps_interface(component_item_id,bill_sequence_id, batch_id,
733: effectivity_date,disable_date)
734: select distinct a.base_model_id, b.bill_sequence_id,
735: cto_msutil_pub.bom_batch_id,effectivity_date,disable_date
736: from bom_ato_configurations a,bom_inventory_components b
737: where a.config_item_id = b.component_item_id
738: and b.bill_sequence_id = lComItmBillId; -- 3543547 lItmBillId
739:
740: end if;