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 1364: --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 || ')';

1360: --Bug 12323522
1361: --Note: The above algorithm resulted int Sysdate for Effectivity_Date if the new effectivigy date is same as the effectivity date in DB.
1362: --So modify the logic as follows
1363: -- Bug 12323522 Commented out start
1364: --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 || ')';
1365: --l_str := l_str || ',' || l_intf_col_name_tbl(i) ||',TO_DATE(NULL, ''DD-MON-YYYY HH24:MI:SS'')';
1366: --l_str := l_str || ',TO_DATE(' || l_intf_col_name_tbl(i) || ',''DD-MON-YYYY HH24:MI:SS'')),';
1367: -- Bug 12323522 Commented out end
1368: --Bug 12323522 Start

Line 1371: l_str := l_str || ', ( SELECT Effectivity_Date FROM Bom_inventory_Components WHERE Component_Sequence_Id = ' || G_INTF_COMP_SEQ_ID || ')),';

1367: -- Bug 12323522 Commented out end
1368: --Bug 12323522 Start
1369: l_str := 'NVL2( ' || l_intf_col_name_tbl(i) ;
1370: l_str := l_str || ', TO_DATE(' || l_intf_col_name_tbl(i) || ', ''DD-MON-YYYY HH24:MI:SS'')';
1371: l_str := l_str || ', ( SELECT Effectivity_Date FROM Bom_inventory_Components WHERE Component_Sequence_Id = ' || G_INTF_COMP_SEQ_ID || ')),';
1372: --Bug 12323522 End
1373: l_dyn_sql_select := l_dyn_sql_select || l_str;
1374: ELSE
1375: IF (l_bom_col_name(i) = G_OPERATION_SEQ_NUM) THEN

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)