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_INVENTORY_COMPONENTS

Line 1321: l_str := 'DECODE(( SELECT To_Char(Effectivity_Date,''DD-MON-YYYY HH24:MI:SS'') FROM Bom_inventory_Components WHERE Component_Sequence_Id = ' || G_INTF_COMP_SEQ_ID || ')';

1317: IF (l_bom_col_name(i) = G_EFFECTIVITY_DATE) THEN
1318: l_dyn_sql_insert := l_dyn_sql_insert || 'NEW_EFFECTIVITY_DATE,';
1319: -- If the new effectivity date is same as the effectivity date in the database
1320: -- then insert null other wise insert new value into the interface table.
1321: l_str := 'DECODE(( SELECT To_Char(Effectivity_Date,''DD-MON-YYYY HH24:MI:SS'') FROM Bom_inventory_Components WHERE Component_Sequence_Id = ' || G_INTF_COMP_SEQ_ID || ')';
1322: l_str := l_str || ',' || l_intf_col_name_tbl(i) ||',TO_DATE(NULL, ''DD-MON-YYYY HH24:MI:SS'')';
1323: l_str := l_str || ',TO_DATE(' || l_intf_col_name_tbl(i) || ',''DD-MON-YYYY HH24:MI:SS'')),';
1324: l_dyn_sql_select := l_dyn_sql_select || l_str;
1325: ELSE

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)