APPS.AHL_PRD_MTLTXN_PVT dependencies on AHL_MTL_RET_DISPOSITIONS_V

Line 2170: FROM AHL_MTL_RET_DISPOSITIONS_V a

2166: p_revision IN VARCHAR2,
2167: p_lotNumber IN VARCHAR2) IS
2168:
2169: SELECT disposition_id, collection_id, condition_code, condition_id
2170: FROM AHL_MTL_RET_DISPOSITIONS_V a
2171: WHERE WORKORDER_ID = p_workorder_id
2172: AND a.disposition_id = p_disposition_id
2173: AND INVENTORY_ITEM_ID = p_inventory_item_id
2174: --AND ORGANIZATION_ID = p_org_id

Line 4952: AHL_MTL_RET_DISPOSITIONS_V a,

4948: * Bug #4918991
4949: */
4950: SELECT SUM(NVL(a.net_quantity,0)) INTO l_disp_qty
4951: FROM
4952: AHL_MTL_RET_DISPOSITIONS_V a,
4953: AHL_WORKORDERS b
4954: WHERE
4955: a.workorder_id=b.workorder_id
4956: AND b.master_workorder_flag = 'N'

Line 5030: AHL_MTL_RET_DISPOSITIONS_V D,

5026: -- JKJAIN FP ER # 6436303 - end
5027: W.wip_entity_id,
5028: (select inv_locator_id from ahl_visits_b where visit_id = w.visit_id) inv_locator_id
5029: FROM
5030: AHL_MTL_RET_DISPOSITIONS_V D,
5031: AHL_WORKORDERS W,
5032: (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'AHL_JOB_STATUS' AND LANGUAGE= USERENV('LANG')) WO_STS,
5033: AHL_VISITS_B V,
5034: AHL_VISIT_TASKS_B VT,

Line 5274: AHL_MTL_RET_DISPOSITIONS_V D,

5270: W.WIP_ENTITY_ID,
5271: V.INV_LOCATOR_ID,
5272: D.PATH_POSITION_ID
5273: FROM
5274: AHL_MTL_RET_DISPOSITIONS_V D,
5275: AHL_VISITS_B V,
5276: AHL_WORKORDER_OPERATIONS O,
5277: MTL_UNITS_OF_MEASURE_VL UOM,
5278: (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = ''AHL_JOB_STATUS'' AND LANGUAGE= USERENV(''LANG'')) WO_STS,

Line 5438: FROM AHL_MTL_RET_DISPOSITIONS_V D

5434: BEGIN
5435: -- calculate total quantity across all dispositions for given item/serial/lot/rev.
5436: SELECT sum(D.Net_quantity)
5437: INTO l_cnt_disposition
5438: FROM AHL_MTL_RET_DISPOSITIONS_V D
5439: WHERE D.WORKORDER_ID = l_wo_id
5440: AND D.INVENTORY_ITEM_ID = l_inv_item_id
5441: AND nvl(D.Serial_Number, '1') = nvl(l_inv_serial, '1')
5442: AND nvl(D.lot_number, '1') = nvl(l_inv_lot_no, '1')

Line 5452: 'Error query ahl_mtl_ret_dispositions_v'

5448: fnd_log.string
5449: (
5450: G_LEVEL_STATEMENT,
5451: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5452: 'Error query ahl_mtl_ret_dispositions_v'
5453: );
5454: END IF;
5455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5456: END;

Line 5967: * BTW there is no code change here, the ahl_mtl_ret_dispositions_v view has been tuned for performance

5963: ) IS
5964: /* Tamal [R12 APPSPERF fixes]
5965: * R12 Drop 4 - SQL ID: 14401875
5966: * Bug #4918991
5967: * BTW there is no code change here, the ahl_mtl_ret_dispositions_v view has been tuned for performance
5968: */
5969: SELECT 'T'
5970: FROM AHL_MTL_RET_DISPOSITIONS_V A
5971: WHERE

Line 5970: FROM AHL_MTL_RET_DISPOSITIONS_V A

5966: * Bug #4918991
5967: * BTW there is no code change here, the ahl_mtl_ret_dispositions_v view has been tuned for performance
5968: */
5969: SELECT 'T'
5970: FROM AHL_MTL_RET_DISPOSITIONS_V A
5971: WHERE
5972: WORKORDER_ID = c_wid AND
5973: INVENTORY_ITEM_ID = c_itemId AND
5974: --ORGANIZATION_ID = c_org_id AND

Line 6658: FROM AHL_MTL_RET_DISPOSITIONS_V disp

6654: /*
6655: CURSOR ahl_disp_csr (p_workorder_id IN NUMBER,
6656: p_instance_id IN NUMBER) IS
6657: SELECT 'X'
6658: FROM AHL_MTL_RET_DISPOSITIONS_V disp
6659: WHERE disp.WORKORDER_ID= p_WORKORDER_ID
6660: AND disp.instance_id = p_instance_id;
6661: */
6662:

Line 6670: FROM AHL_MTL_RET_DISPOSITIONS_V D

6666: p_lot_number IN VARCHAR2,
6667: p_item_revision IN VARCHAR2)
6668: IS
6669: SELECT 'X'
6670: FROM AHL_MTL_RET_DISPOSITIONS_V D
6671: WHERE D.WORKORDER_ID = p_workorder_id
6672: AND D.INVENTORY_ITEM_ID = p_inventory_item_id
6673: AND nvl(D.Serial_Number, '1') = nvl(p_serial_number, '1')
6674: AND nvl(D.lot_number, '1') = nvl(p_lot_number, '1')