APPS.AHL_PRD_WORKORDER_PVT dependencies on INV_ORGANIZATION_NAME_V

Line 967: with INV_ORGANIZATION_NAME_V.

963: CURSOR validate_org(c_org_id NUMBER)
964: IS
965:
966: /* Perf. fix for bug# 4949394. Replace ORG_ORGANIZATION_DEFINITIONS
967: with INV_ORGANIZATION_NAME_V.
968: SELECT a.organization_id,
969: b.eam_enabled_flag
970: FROM ORG_ORGANIZATION_DEFINITIONS a,MTL_PARAMETERS b
971: WHERE a.organization_id=b.organization_id

Line 977: FROM INV_ORGANIZATION_NAME_V a,MTL_PARAMETERS b

973: */
974:
975: SELECT a.organization_id,
976: b.eam_enabled_flag
977: FROM INV_ORGANIZATION_NAME_V a,MTL_PARAMETERS b
978: WHERE a.organization_id=b.organization_id
979: AND a.organization_id=c_org_id;
980:
981: l_org_rec validate_org%ROWTYPE;