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

Line 374: FROM BOM_BILL_OF_MATERIALS B

370: l_stmt_num := 40;
371:
372: SELECT B.BILL_SEQUENCE_ID, B.ORGANIZATION_ID
373: INTO x_bill_sequence_id, x_org_id
374: FROM BOM_BILL_OF_MATERIALS B
375: WHERE B.ASSEMBLY_ITEM_ID = p_assembly_item_id
376: AND B.ORGANIZATION_ID = p_organization_id
377: AND (
378: (

Line 386: SELECT 'X' FROM BOM_BILL_OF_MATERIALS C

382: (
383: B.ALTERNATE_BOM_DESIGNATOR IS NULL AND
384: NOT EXISTS
385: (
386: SELECT 'X' FROM BOM_BILL_OF_MATERIALS C
387: WHERE C.ASSEMBLY_ITEM_ID = p_assembly_item_id
388: AND C.ORGANIZATION_ID = p_organization_id
389: AND C.ALTERNATE_BOM_DESIGNATOR = p_alt_bom
390: )

Line 513: FROM BOM_BILL_OF_MATERIALS B

509: x_phan_qty := t_comp_details(i).qpa;
510:
511: SELECT B.BILL_SEQUENCE_ID, B.ORGANIZATION_ID
512: INTO x_bill_sequence_id, x_org_id
513: FROM BOM_BILL_OF_MATERIALS B
514: WHERE B.ASSEMBLY_ITEM_ID = t_comp_details(i).component_item_id
515: AND B.ORGANIZATION_ID = p_organization_id
516: AND B.ALTERNATE_BOM_DESIGNATOR IS NULL;
517: