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 723: (SELECT NULL FROM Bom_structures_b bsb

719: REQUEST_ID = C_REQUEST_ID
720: AND
721: BMI.Alternate_Bom_Designator IS NOT NULL
722: AND NOT EXISTS
723: (SELECT NULL FROM Bom_structures_b bsb
724: WHERE bsb.Assembly_Item_id IN (SELECT Inventory_item_id FROM mtl_system_items_vl WHERE concatenated_segments = bmi.Item_number)
725: AND bsb.Organization_id = (SELECT ORGANIZATION_ID FROM mtl_parameters WHERE ORGANIZATION_code = bmi.ORGANIZATION_code)
726: AND bsb.Alternate_Bom_Designator IS NULL
727: );

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

951: l_dyn_sql := 'UPDATE EGO_BULKLOAD_INTF EBI';
952: l_dyn_sql := l_dyn_sql || ' SET INSTANCE_PK4_VALUE = ';
953: l_dyn_sql := l_dyn_sql || ' ( ';
954: l_dyn_sql := l_dyn_sql || ' SELECT bill_sequence_id ';
955: l_dyn_sql := l_dyn_sql || ' FROM bom_structures_b bsb, mtl_system_items_vl mvll ';
956: l_dyn_sql := l_dyn_sql || ' WHERE mvll.concatenated_segments = EBI.'|| l_parent_column;
957: l_dyn_sql := l_dyn_sql || ' AND mvll.organization_id = EBI.INSTANCE_PK2_VALUE';
958: l_dyn_sql := l_dyn_sql || ' AND bsb.assembly_item_id = mvll.inventory_item_id';
959: l_dyn_sql := l_dyn_sql || ' AND bsb.organization_id = mvll.organization_id';

Line 1850: FROM BOM_STRUCTURES_B

1846: BEGIN
1847:
1848: SELECT Bill_Sequence_id, Common_Bill_Sequence_id, Source_Bill_Sequence_id
1849: INTO l_Bill_Sequence_id, l_Common_Bill_Sequence_Id, l_Source_Bill_Sequence_Id
1850: FROM BOM_STRUCTURES_B
1851: WHERE assembly_item_id = p_assembly_item_id
1852: AND organization_id = p_organization_id
1853: AND NVL(alternate_bom_designator , Fnd_Api.G_MISS_CHAR) = NVL(p_alternate_bom_designator, Fnd_Api.G_MISS_CHAR);
1854:

Line 1878: FROM BOM_INVENTORY_COMPONENTS BIC, bom_structures_b bsb

1874: -- Update the components with new component sequence id
1875: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
1876: SET COMPONENT_SEQUENCE_ID
1877: = (SELECT COMPONENT_SEQUENCE_ID
1878: FROM BOM_INVENTORY_COMPONENTS BIC, bom_structures_b bsb
1879: WHERE BIC.bill_sequence_id = bsb.bill_Sequence_id
1880: AND bsb.assembly_item_id = p_assembly_item_id
1881: AND bsb.organization_id = p_organization_id
1882: AND NVL(bsb.alternate_bom_designator , Fnd_Api.G_MISS_CHAR) = NVL(p_alternate_bom_designator, Fnd_Api.G_MISS_CHAR)