DBA Data[Home] [Help]

APPS.AHL_PRD_DISP_MTL_TXN_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 46: SELECT 'x', fnd.meaning from ahl_workorders wo, fnd_lookup_values_vl fnd

42:
43: -- Change made by jaramana on August 8, 2007 for bug 6326065 (FP of 6061600)
44: -- Start allowing Disp Txn association for Complete workorders (code 4)
45: cursor workorder_editable_csr(p_workorder_id IN NUMBER) IS
46: SELECT 'x', fnd.meaning from ahl_workorders wo, fnd_lookup_values_vl fnd
47: WHERE workorder_id = p_workorder_id
48: AND wo.status_code IN ('12','7','17','22','5')
49: and fnd.lookup_type = 'AHL_JOB_STATUS' and fnd.lookup_code = wo.status_code;
50: --AND wo.JOB_STATUS_CODE IN ('Closed', 'Cancelled','Draft','Deleted','Complete No-charge');