DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on INV_ORGANIZATION_NAME_V

Line 1074: with INV_ORGANIZATION_NAME_V.

1070: CURSOR validate_org(c_org_id NUMBER)
1071: IS
1072:
1073: /* Perf. fix for bug# 4949394. Replace ORG_ORGANIZATION_DEFINITIONS
1074: with INV_ORGANIZATION_NAME_V.
1075: SELECT a.organization_id,
1076: b.eam_enabled_flag
1077: FROM ORG_ORGANIZATION_DEFINITIONS a,MTL_PARAMETERS b
1078: WHERE a.organization_id=b.organization_id

Line 1084: FROM INV_ORGANIZATION_NAME_V a,MTL_PARAMETERS b

1080: */
1081:
1082: SELECT a.organization_id,
1083: b.eam_enabled_flag
1084: FROM INV_ORGANIZATION_NAME_V a,MTL_PARAMETERS b
1085: WHERE a.organization_id=b.organization_id
1086: AND a.organization_id=c_org_id;
1087:
1088: l_org_rec validate_org%ROWTYPE;