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.WSMPVLDT dependencies on BOM_BILL_OF_MATERIALS

Line 6424: from bom_bill_of_materials bom,

6420: l_stmt_num := 161;
6421: UPDATE wsm_resulting_jobs_interface wrji
6422: SET common_bom_sequence_id=
6423: (select bom.common_bill_sequence_id
6424: from bom_bill_of_materials bom,
6425: mtl_system_items msi --bugfix 1828859
6426: where bom.assembly_item_id = wrji.primary_item_id
6427: and bom.alternate_bom_designator is null
6428: and bom.organization_id = l_organization_id --bugfix 1922146: added orgn_id condn

Line 6473: from bom_bill_of_materials bom,

6469: WHERE wrji.header_id = l_header_id
6470: AND wrji.rowid = l_wrji_rowid --SpUA add
6471: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
6472: AND NOT EXISTS (select 1
6473: from bom_bill_of_materials bom,
6474: mtl_system_items msi --bugfix 1828859
6475: where bom.bill_sequence_id = wrji.common_bom_sequence_id
6476: and bom.alternate_bom_designator = wrji.alternate_bom_designator
6477: and bom.organization_id = l_organization_id

Line 6515: from bom_bill_of_materials bom,

6511: WHERE wrji.header_id = l_header_id
6512: AND wrji.rowid = l_wrji_rowid --SpUA add
6513: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
6514: AND NOT EXISTS (select 1
6515: from bom_bill_of_materials bom,
6516: mtl_system_items msi --bugfix 1828859
6517: where bom.bill_sequence_id = wrji.common_bom_sequence_id
6518: --and bom.assembly_item_id=wrji.primary_item_id --bugfix 2077930
6519: and bom.organization_id = l_organization_id -- bugfix 1922146: added orgn_id condn

Line 6530: from bom_bill_of_materials bom,

6526: if (SQL%ROWCOUNT=0) then
6527: l_stmt_num := 164;
6528: UPDATE wsm_resulting_jobs_interface wrji
6529: SET wrji.alternate_bom_designator = (select bom.alternate_bom_designator
6530: from bom_bill_of_materials bom,
6531: mtl_system_items msi --bugfix 1828859
6532: where bom.bill_sequence_id = wrji.common_bom_sequence_id
6533: --and bom.assembly_item_id=wrji.primary_item_id --bugfix 2077930
6534: and bom.organization_id = l_organization_id

Line 6594: from bom_bill_of_materials bom,

6590: WHERE wrji.header_id = l_header_id
6591: AND wrji.rowid = l_wrji_rowid --SpUA add
6592: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
6593: and NOT EXISTS (select 1
6594: from bom_bill_of_materials bom,
6595: mtl_system_items msi --bugfix 1828859
6596: where bom.alternate_bom_designator = wrji.alternate_bom_designator
6597: and bom.assembly_item_id = wrji.primary_item_id
6598: and bom.organization_id = l_organization_id -- bugfix 1922146: added orgn_id condn

Line 6609: from bom_bill_of_materials bom,

6605: if (SQL%ROWCOUNT=0) then
6606: l_stmt_num := 166;
6607: UPDATE wsm_resulting_jobs_interface wrji
6608: SET wrji.common_bom_sequence_id = (select bom.common_bill_sequence_id
6609: from bom_bill_of_materials bom,
6610: mtl_system_items msi --bugfix 1828859
6611: where bom.alternate_bom_designator = wrji.alternate_bom_designator
6612: and bom.assembly_item_id = wrji.primary_item_id
6613: and bom.organization_id = l_organization_id