APPS.EAM_ASSET_MOVE_PUB dependencies on WIP_EAM_PARAMETERS

Line 410: INTO l_intermediate_subinventory FROM WIP_EAM_PARAMETERS

406: FOR i IN p_asset_move_hierarchy_tbl.FIRST .. p_asset_move_hierarchy_tbl.LAST
407: LOOP
408: BEGIN
409: SELECT INTERMEDIATE_SUBINVENTORY
410: INTO l_intermediate_subinventory FROM WIP_EAM_PARAMETERS
411: WHERE ORGANIZATION_ID = p_asset_move_hierarchy_tbl(i).maint_org_id ;
412:
413: INSERT
414: INTO EAM_ASSET_MOVE_TEMP

Line 654: from wip_eam_parameters

650: from MTL_PARAMETERS
651: where ORGANIZATION_ID = P_CURRENT_ORGANIZATION_ID;
652: --Added for the bug 7681240
653: select INTERMEDIATE_SUBINVENTORY into l_intermediate_subinventory
654: from wip_eam_parameters
655: where ORGANIZATION_ID = l_maint_organization_id;
656: EXCEPTION
657: WHEN No_Data_Found THEN
658: l_intermediate_subinventory := NULL;

Line 663: from wip_eam_parameters

659: END;
660:
661: BEGIN
662: select INTERMEDIATE_LOCATOR into l_intermediate_locator
663: from wip_eam_parameters
664: where ORGANIZATION_ID = l_maint_organization_id;
665: EXCEPTION
666: WHEN No_Data_Found THEN
667: l_intermediate_locator := NULL;

Line 734: --make nvl(validAssets_rec.CURRENT_SUBINVENTORY_CODE,WIP_EAM_PARAMETERS.default_Subinventory) for the current SI

730: l_serial_number :=validAssets_rec.serial_number;
731: l_from_ser_number:=validAssets_rec.serial_number;
732: l_to_ser_number :=validAssets_rec.serial_number;
733: l_CURRENT_ORGANIZATION_ID:=validAssets_rec.CURRENT_ORG_ID;
734: --make nvl(validAssets_rec.CURRENT_SUBINVENTORY_CODE,WIP_EAM_PARAMETERS.default_Subinventory) for the current SI
735:
736: l_current_subinventory_code :=nvl(validAssets_rec.CURRENT_SUBINVENTORY_CODE,l_intermediate_subinventory);
737: l_transaction_type_id:=p_transaction_type_id;
738: