DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on MTL_PARAMETERS

Line 970: FROM ORG_ORGANIZATION_DEFINITIONS a,MTL_PARAMETERS b

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
972: AND a.organization_id=c_org_id;
973: */
974:

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;

Line 1005: MTL_PARAMETERS b

1001: SELECT a.organization_id,
1002: a.secondary_inventory,
1003: b.eam_enabled_flag
1004: FROM MTL_ITEM_SUB_INVENTORIES a,
1005: MTL_PARAMETERS b
1006: WHERE a.organization_id=b.organization_id
1007: AND a.organization_id=c_org_id
1008: AND a.secondary_inventory=c_sub_inv;
1009:

Line 1021: FROM MTL_PARAMETERS mpr

1017:
1018: CURSOR validate_project(C_org_id NUMBER)
1019: IS
1020: SELECT 1
1021: FROM MTL_PARAMETERS mpr
1022: WHERE mpr.organization_id=c_org_id
1023: AND NVL(mpr.project_reference_enabled,2)=1;
1024:
1025: CURSOR get_visit_wo_dates(c_visit_id NUMBER)