DBA Data[Home] [Help]

APPS.AHL_AMP_WORKBENCH_PVT dependencies on BOM_DEPARTMENTS

Line 514: BOM_DEPARTMENTS BDPT

510: ASPL.BOM_DEPARTMENT_ID DEPARTMENT_ID,
511: ASPL.ORGANIZATION_ID,
512: BDPT.DESCRIPTION DEPT_DESCRIPTION
513: FROM AHL_SPACES_VL ASPL,
514: BOM_DEPARTMENTS BDPT
515: WHERE ASPL.BOM_DEPARTMENT_ID = BDPT.DEPARTMENT_ID
516: AND ASPL.ORGANIZATION_ID = c_org_id
517: AND ASPL.INACTIVE_FLAG LIKE 'Y'
518:

Line 526: FROM BOM_DEPARTMENTS BOM,

522: NULL SPACE_NAME,
523: BOM.DEPARTMENT_ID,
524: ORG.ORGANIZATION_ID,
525: BOM.DESCRIPTION DEPT_DESCRIPTION
526: FROM BOM_DEPARTMENTS BOM,
527: INV_ORGANIZATION_INFO_V ORG,
528: MTL_PARAMETERS MP
529: WHERE BOM.ORGANIZATION_ID = ORG.ORGANIZATION_ID
530: AND MP.ORGANIZATION_ID = BOM.ORGANIZATION_ID