APPS.AHL_PRD_DISP_UTIL_PVT dependencies on MTL_MATERIAL_STATUSES

Line 83: FROM mtl_material_statuses

79: AND organization_id = c_organization_id;
80:
81: CURSOR check_con_status_id(c_status_id VARCHAR2) IS
82: SELECT status_id
83: FROM mtl_material_statuses
84: WHERE status_id = c_status_id;
85:
86: CURSOR get_con_status_id(c_status_code VARCHAR2) IS
87: SELECT status_id

Line 88: FROM mtl_material_statuses

84: WHERE status_id = c_status_id;
85:
86: CURSOR get_con_status_id(c_status_code VARCHAR2) IS
87: SELECT status_id
88: FROM mtl_material_statuses
89: WHERE status_code = c_status_code;
90:
91: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 17-Dec-2007
92: -- The OFF and ON quantity for the search UI table needs to be set with the

Line 909: MTL_MATERIAL_STATUSES_TL COND,

905: AHL_MC_PATH_POSITIONS pp,
906: MTL_SYSTEM_ITEMS_KFV MTL,
907: CSI_ITEM_INSTANCES CSI,
908: AHL_ITEM_GROUPS_B GRP,
909: MTL_MATERIAL_STATUSES_TL COND,
910: CS_INCIDENTS_ALL_B INC,
911: CS_INCIDENTS_ALL_TL INCL,
912: CS_INCIDENT_SEVERITIES_TL SEV,
913: FND_LOOKUP_VALUES PCODE,

Line 1059: MTL_MATERIAL_STATUSES_TL COND,

1055: FND_LOOKUP_VALUES PCODE,
1056: MTL_SYSTEM_ITEMS_KFV MTL,
1057: CSI_ITEM_INSTANCES CSI,
1058: AHL_ITEM_GROUPS_B GRP,
1059: MTL_MATERIAL_STATUSES_TL COND,
1060: FND_LOOKUP_VALUES FND1,
1061: FND_LOOKUP_VALUES FND2,
1062: FND_LOOKUP_VALUES FND3
1063: WHERE pp.path_pos_common_id IN (

Line 1203: MTL_MATERIAL_STATUSES_TL COND,

1199: AHL_MC_PATH_POSITIONS pp,
1200: FND_LOOKUP_VALUES FND1,
1201: FND_LOOKUP_VALUES FND2,
1202: FND_LOOKUP_VALUES FND3,
1203: MTL_MATERIAL_STATUSES_TL COND,
1204: AHL_ITEM_GROUPS_B GRP,
1205: MTL_SYSTEM_ITEMS_KFV MTL,
1206: CSI_ITEM_INSTANCES CSI,
1207: CS_INCIDENTS_ALL_B INC,