APPS.AHL_PRD_MTLTXN_PVT dependencies on AHL_MTL_RET_DISPOSITIONS_V

Line 1881: FROM AHL_MTL_RET_DISPOSITIONS_V a

1877: p_revision IN VARCHAR2,
1878: p_lotNumber IN VARCHAR2) IS
1879:
1880: SELECT disposition_id
1881: FROM AHL_MTL_RET_DISPOSITIONS_V a
1882: WHERE WORKORDER_ID = p_workorder_id
1883: AND a.disposition_id = p_disposition_id
1884: AND INVENTORY_ITEM_ID = p_inventory_item_id
1885: --AND ORGANIZATION_ID = p_org_id

Line 4236: AHL_MTL_RET_DISPOSITIONS_V a,

4232: * Bug #4918991
4233: */
4234: SELECT SUM(NVL(a.net_quantity,0)) INTO l_disp_qty
4235: FROM
4236: AHL_MTL_RET_DISPOSITIONS_V a,
4237: AHL_WORKORDERS b
4238: WHERE
4239: a.workorder_id=b.workorder_id
4240: AND b.master_workorder_flag = 'N'

Line 4311: AHL_MTL_RET_DISPOSITIONS_V D,

4307: -- JKJAIN FP ER # 6436303 - end
4308: W.wip_entity_id,
4309: (select inv_locator_id from ahl_visits_b where visit_id = w.visit_id) inv_locator_id
4310: FROM
4311: AHL_MTL_RET_DISPOSITIONS_V D,
4312: AHL_WORKORDERS W,
4313: (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'AHL_JOB_STATUS' AND LANGUAGE= USERENV('LANG')) WO_STS,
4314: AHL_VISITS_B V,
4315: AHL_VISIT_TASKS_B VT,

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

4609: ) IS
4610: /* Tamal [R12 APPSPERF fixes]
4611: * R12 Drop 4 - SQL ID: 14401875
4612: * Bug #4918991
4613: * BTW there is no code change here, the ahl_mtl_ret_dispositions_v view has been tuned for performance
4614: */
4615: SELECT 'T'
4616: FROM AHL_MTL_RET_DISPOSITIONS_V A
4617: WHERE

Line 4616: FROM AHL_MTL_RET_DISPOSITIONS_V A

4612: * Bug #4918991
4613: * BTW there is no code change here, the ahl_mtl_ret_dispositions_v view has been tuned for performance
4614: */
4615: SELECT 'T'
4616: FROM AHL_MTL_RET_DISPOSITIONS_V A
4617: WHERE
4618: WORKORDER_ID = c_wid AND
4619: INVENTORY_ITEM_ID = c_itemId AND
4620: --ORGANIZATION_ID = c_org_id AND

Line 5155: FROM AHL_MTL_RET_DISPOSITIONS_V disp

5151: -- Check existence of disposition.
5152: CURSOR ahl_disp_csr (p_workorder_id IN NUMBER,
5153: p_instance_id IN NUMBER) IS
5154: SELECT 'X'
5155: FROM AHL_MTL_RET_DISPOSITIONS_V disp
5156: WHERE disp.WORKORDER_ID= p_WORKORDER_ID
5157: AND disp.instance_id = p_instance_id;
5158:
5159: l_index NUMBER := p_x_ahl_prd_mtl_txn_tbl.count;