eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PRD_DISP_MTL_TXN_PVT dependencies on FND_LOOKUP_VALUES

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');

Line 768: fnd_lookup_values flvt1,

764: FROM ahl_prd_dispositions_vl disp,
765: ahl_prd_disp_mtl_txns assoc,
766: mtl_system_items_kfv mtl,
767: ahl_item_groups_b grp,
768: fnd_lookup_values flvt1,
769: fnd_lookup_values flvt2,
770: fnd_lookup_values flvt3
771: WHERE (
772: ( disp.disposition_id = assoc.disposition_id --Either match on existing reln

Line 769: fnd_lookup_values flvt2,

765: ahl_prd_disp_mtl_txns assoc,
766: mtl_system_items_kfv mtl,
767: ahl_item_groups_b grp,
768: fnd_lookup_values flvt1,
769: fnd_lookup_values flvt2,
770: fnd_lookup_values flvt3
771: WHERE (
772: ( disp.disposition_id = assoc.disposition_id --Either match on existing reln
773: AND

Line 770: fnd_lookup_values flvt3

766: mtl_system_items_kfv mtl,
767: ahl_item_groups_b grp,
768: fnd_lookup_values flvt1,
769: fnd_lookup_values flvt2,
770: fnd_lookup_values flvt3
771: WHERE (
772: ( disp.disposition_id = assoc.disposition_id --Either match on existing reln
773: AND
774: assoc.workorder_mtl_txn_id = p_mtl_txn_id

Line 862: fnd_lookup_values flvt1,

858: FROM ahl_prd_dispositions_vl disp,
859: ahl_prd_disp_mtl_txns assoc,
860: mtl_system_items_kfv mtl,
861: ahl_item_groups_b grp,
862: fnd_lookup_values flvt1,
863: fnd_lookup_values flvt2,
864: fnd_lookup_values flvt3
865: WHERE (
866: ( disp.disposition_id = assoc.disposition_id

Line 863: fnd_lookup_values flvt2,

859: ahl_prd_disp_mtl_txns assoc,
860: mtl_system_items_kfv mtl,
861: ahl_item_groups_b grp,
862: fnd_lookup_values flvt1,
863: fnd_lookup_values flvt2,
864: fnd_lookup_values flvt3
865: WHERE (
866: ( disp.disposition_id = assoc.disposition_id
867: and assoc.workorder_mtl_txn_id = p_mtl_txn_id

Line 864: fnd_lookup_values flvt3

860: mtl_system_items_kfv mtl,
861: ahl_item_groups_b grp,
862: fnd_lookup_values flvt1,
863: fnd_lookup_values flvt2,
864: fnd_lookup_values flvt3
865: WHERE (
866: ( disp.disposition_id = assoc.disposition_id
867: and assoc.workorder_mtl_txn_id = p_mtl_txn_id
868: )