DBA Data[Home] [Help]

APPS.AHL_PRD_DISP_UTIL_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 71: FROM mtl_system_items_kfv

67: WHERE name = c_item_group_name;
68:
69: CURSOR check_inv_item_id(c_inventory_item_id NUMBER, c_organization_id NUMBER) IS
70: SELECT inventory_item_id
71: FROM mtl_system_items_kfv
72: WHERE inventory_item_id = c_inventory_item_id
73: AND organization_id = c_organization_id;
74:
75: CURSOR get_inv_item_id(c_item_number VARCHAR2, c_organization_id NUMBER) IS

Line 77: FROM mtl_system_items_kfv

73: AND organization_id = c_organization_id;
74:
75: CURSOR get_inv_item_id(c_item_number VARCHAR2, c_organization_id NUMBER) IS
76: SELECT inventory_item_id
77: FROM mtl_system_items_kfv
78: WHERE concatenated_segments = c_item_number
79: AND organization_id = c_organization_id;
80:
81: CURSOR check_con_status_id(c_status_id VARCHAR2) IS

Line 113: mtl_system_items_kfv OFFI,

109: PC.installed_quantity on_quantity,
110: ONC.unit_of_measure on_uom
111: FROM ahl_part_changes_v PC,
112: csi_item_instances OFFC,
113: mtl_system_items_kfv OFFI,
114: csi_item_instances ONC,
115: mtl_system_items_kfv ONI
116: WHERE PC.part_change_id = c_part_change_id
117: AND PC.removed_instance_id = OFFC.instance_id (+)

Line 115: mtl_system_items_kfv ONI

111: FROM ahl_part_changes_v PC,
112: csi_item_instances OFFC,
113: mtl_system_items_kfv OFFI,
114: csi_item_instances ONC,
115: mtl_system_items_kfv ONI
116: WHERE PC.part_change_id = c_part_change_id
117: AND PC.removed_instance_id = OFFC.instance_id (+)
118: AND PC.installed_instance_id = ONC.instance_id (+)
119: AND OFFC.inventory_item_id = OFFI.inventory_item_id (+)

Line 147: mtl_system_items_kfv IV

143: DM.quantity quantity,
144: DM.uom uom
145: FROM ahl_workorder_mtl_txns MT,
146: ahl_prd_disp_mtl_txns DM,
147: mtl_system_items_kfv IV
148: WHERE DM.disposition_id = c_disposition_id
149: AND MT.workorder_mtl_txn_id = DM.workorder_mtl_txn_id
150: AND MT.transaction_type_id = c_txn_type_id
151: AND MT.inventory_item_id = IV.inventory_item_id

Line 906: MTL_SYSTEM_ITEMS_KFV MTL,

902: INCL.SUMMARY
903: FROM AHL_PRD_DISPOSITIONS_b disp,
904: AHL_PRD_DISPOSITIONS_tl displ,
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,

Line 1056: MTL_SYSTEM_ITEMS_KFV MTL,

1052: CS_INCIDENTS_ALL_B INC,
1053: CS_INCIDENTS_ALL_TL INCL,
1054: CS_INCIDENT_SEVERITIES_TL SEV,
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,

Line 1205: MTL_SYSTEM_ITEMS_KFV MTL,

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,
1208: CS_INCIDENTS_ALL_TL INCL,
1209: CS_INCIDENT_SEVERITIES_TL SEV,

Line 1886: mtl_system_items_kfv mtl,

1882: disp.quantity,
1883: disp.uom,
1884: disp.wo_operation_id
1885: from ahl_prd_dispositions_vl disp,
1886: mtl_system_items_kfv mtl,
1887: ahl_workorders wo,
1888: ahl_visits_b vi
1889: where disp.workorder_id = wo.workorder_id
1890: and wo.visit_id = vi.visit_id

Line 1926: FROM AHL_ITEM_ASSOCIATIONS_B ia, MTL_SYSTEM_ITEMS_KFV mtl,

1922: --Based on the position, fetch the highest priority item from item group.
1923: CURSOR get_empty_pos_item_csr(p_relationship_id IN NUMBER,
1924: p_org_id IN NUMBER ) IS
1925: SELECT ia.inventory_item_id, mtl.concatenated_segments, ia.quantity, ia.uom_code
1926: FROM AHL_ITEM_ASSOCIATIONS_B ia, MTL_SYSTEM_ITEMS_KFV mtl,
1927: AHL_MC_RELATIONSHIPS rel, MTL_PARAMETERS morgs
1928: WHERE ia.inventory_item_id = mtl.inventory_item_id
1929: AND mtl.organization_id = p_org_id --Make sure item is defined for p_org_id
1930: AND ia.inventory_org_id = morgs.master_organization_id

Line 1942: FROM AHL_ITEM_ASSOCIATIONS_B ia, MTL_SYSTEM_ITEMS_KFV mtl,

1938: -- look into sub-unit top nodes for best matched item.
1939: CURSOR get_pos_subut_item_csr(p_relationship_id IN NUMBER,
1940: p_org_id IN NUMBER ) IS
1941: SELECT ia.inventory_item_id, mtl.concatenated_segments, ia.quantity, ia.uom_code
1942: FROM AHL_ITEM_ASSOCIATIONS_B ia, MTL_SYSTEM_ITEMS_KFV mtl,
1943: AHL_MC_RELATIONSHIPS rel, AHL_MC_CONFIG_RELATIONS crel, MTL_PARAMETERS morgs
1944: WHERE ia.inventory_item_id = mtl.inventory_item_id
1945: AND mtl.organization_id = p_org_id --Make sure item is defined for p_org_id
1946: AND ia.inventory_org_id = morgs.master_organization_id

Line 1987: l_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;

1983: l_req_material_tbl AHL_PP_Materials_PVT.req_material_tbl_type;
1984: l_req_material_u_rec AHL_PP_Materials_PVT.req_material_rec_type;
1985: l_req_material_u_tbl AHL_PP_Materials_PVT.req_material_tbl_type;
1986: l_disp_rec get_disp_dtls_csr%ROWTYPE;
1987: l_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1988: l_relationship_id NUMBER;
1989: l_job_return_status VARCHAR2(1);
1990: l_delta_quantity NUMBER;
1991: -- Added on 1/8/05 by JR to fix Bug 4097327