APPS.AHL_PRD_WORKORDER_PVT dependencies on MTL_PARAMETERS

Line 1077: FROM ORG_ORGANIZATION_DEFINITIONS a,MTL_PARAMETERS b

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
1079: AND a.organization_id=c_org_id;
1080: */
1081:

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;

Line 1113: MTL_PARAMETERS b

1109: SELECT a.organization_id,
1110: a.secondary_inventory,
1111: b.eam_enabled_flag
1112: FROM MTL_ITEM_SUB_INVENTORIES a,
1113: MTL_PARAMETERS b
1114: WHERE a.organization_id=b.organization_id
1115: AND a.organization_id=c_org_id
1116: AND a.secondary_inventory=c_sub_inv;
1117:

Line 1129: FROM MTL_PARAMETERS mpr

1125:
1126: CURSOR validate_project(C_org_id NUMBER)
1127: IS
1128: SELECT 1
1129: FROM MTL_PARAMETERS mpr
1130: WHERE mpr.organization_id=c_org_id
1131: AND NVL(mpr.project_reference_enabled,2)=1;
1132:
1133: CURSOR get_visit_wo_dates(c_visit_id NUMBER)