DBA Data[Home] [Help]

APPS.CTO_BOM_RTG_PK dependencies on BOM_INVENTORY_COMPONENTS

Line 701: from bom_inventory_components

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
705: oe_debug_pub.add('Value of gMatch '||CTO_MATCH_CONFIG.gMatch ,1);

Line 733: from bom_ato_configurations a,bom_inventory_components b

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:
737: end if;