eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_BULKLOAD_PVT_PKG dependencies on BOM_STRUCTURES_B

Line 737: (SELECT NULL FROM Bom_structures_b bsb

733: REQUEST_ID = C_REQUEST_ID
734: AND
735: BMI.Alternate_Bom_Designator IS NOT NULL
736: AND NOT EXISTS
737: (SELECT NULL FROM Bom_structures_b bsb
738: WHERE bsb.Assembly_Item_id IN (SELECT Inventory_item_id FROM mtl_system_items_vl WHERE concatenated_segments = bmi.Item_number)
739: AND bsb.Organization_id = (SELECT ORGANIZATION_ID FROM mtl_parameters WHERE ORGANIZATION_code = bmi.ORGANIZATION_code)
740: AND bsb.Alternate_Bom_Designator IS NULL
741: );

Line 984: l_dyn_sql := l_dyn_sql || ' FROM bom_structures_b bsb, mtl_system_items_vl mvll ';

980: l_dyn_sql := 'UPDATE EGO_BULKLOAD_INTF EBI';
981: l_dyn_sql := l_dyn_sql || ' SET INSTANCE_PK4_VALUE = ';
982: l_dyn_sql := l_dyn_sql || ' ( ';
983: l_dyn_sql := l_dyn_sql || ' SELECT bill_sequence_id ';
984: l_dyn_sql := l_dyn_sql || ' FROM bom_structures_b bsb, mtl_system_items_vl mvll ';
985: l_dyn_sql := l_dyn_sql || ' WHERE mvll.concatenated_segments = EBI.'|| l_parent_column;
986: l_dyn_sql := l_dyn_sql || ' AND mvll.organization_id = EBI.INSTANCE_PK2_VALUE';
987: l_dyn_sql := l_dyn_sql || ' AND bsb.assembly_item_id = mvll.inventory_item_id';
988: l_dyn_sql := l_dyn_sql || ' AND bsb.organization_id = mvll.organization_id';

Line 1940: FROM BOM_STRUCTURES_B

1936: BEGIN
1937:
1938: SELECT Bill_Sequence_id, Common_Bill_Sequence_id, Source_Bill_Sequence_id
1939: INTO l_Bill_Sequence_id, l_Common_Bill_Sequence_Id, l_Source_Bill_Sequence_Id
1940: FROM BOM_STRUCTURES_B
1941: WHERE assembly_item_id = p_assembly_item_id
1942: AND organization_id = p_organization_id
1943: AND NVL(alternate_bom_designator , Fnd_Api.G_MISS_CHAR) = NVL(p_alternate_bom_designator, Fnd_Api.G_MISS_CHAR);
1944:

Line 1968: FROM BOM_INVENTORY_COMPONENTS BIC, bom_structures_b bsb

1964: -- Update the components with new component sequence id
1965: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
1966: SET COMPONENT_SEQUENCE_ID
1967: = (SELECT COMPONENT_SEQUENCE_ID
1968: FROM BOM_INVENTORY_COMPONENTS BIC, bom_structures_b bsb
1969: WHERE BIC.bill_sequence_id = bsb.bill_Sequence_id
1970: AND bsb.assembly_item_id = p_assembly_item_id
1971: AND bsb.organization_id = p_organization_id
1972: AND NVL(bsb.alternate_bom_designator , Fnd_Api.G_MISS_CHAR) = NVL(p_alternate_bom_designator, Fnd_Api.G_MISS_CHAR)