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 756: fnd_lookup_values flvt1,

752: FROM ahl_prd_dispositions_vl disp,
753: ahl_prd_disp_mtl_txns assoc,
754: mtl_system_items_kfv mtl,
755: ahl_item_groups_b grp,
756: fnd_lookup_values flvt1,
757: fnd_lookup_values flvt2,
758: fnd_lookup_values flvt3
759: WHERE (
760: ( disp.disposition_id = assoc.disposition_id --Either match on existing reln

Line 757: fnd_lookup_values flvt2,

753: ahl_prd_disp_mtl_txns assoc,
754: mtl_system_items_kfv mtl,
755: ahl_item_groups_b grp,
756: fnd_lookup_values flvt1,
757: fnd_lookup_values flvt2,
758: fnd_lookup_values flvt3
759: WHERE (
760: ( disp.disposition_id = assoc.disposition_id --Either match on existing reln
761: AND

Line 758: fnd_lookup_values flvt3

754: mtl_system_items_kfv mtl,
755: ahl_item_groups_b grp,
756: fnd_lookup_values flvt1,
757: fnd_lookup_values flvt2,
758: fnd_lookup_values flvt3
759: WHERE (
760: ( disp.disposition_id = assoc.disposition_id --Either match on existing reln
761: AND
762: assoc.workorder_mtl_txn_id = p_mtl_txn_id

Line 850: fnd_lookup_values flvt1,

846: FROM ahl_prd_dispositions_vl disp,
847: ahl_prd_disp_mtl_txns assoc,
848: mtl_system_items_kfv mtl,
849: ahl_item_groups_b grp,
850: fnd_lookup_values flvt1,
851: fnd_lookup_values flvt2,
852: fnd_lookup_values flvt3
853: WHERE (
854: ( disp.disposition_id = assoc.disposition_id

Line 851: fnd_lookup_values flvt2,

847: ahl_prd_disp_mtl_txns assoc,
848: mtl_system_items_kfv mtl,
849: ahl_item_groups_b grp,
850: fnd_lookup_values flvt1,
851: fnd_lookup_values flvt2,
852: fnd_lookup_values flvt3
853: WHERE (
854: ( disp.disposition_id = assoc.disposition_id
855: and assoc.workorder_mtl_txn_id = p_mtl_txn_id

Line 852: fnd_lookup_values flvt3

848: mtl_system_items_kfv mtl,
849: ahl_item_groups_b grp,
850: fnd_lookup_values flvt1,
851: fnd_lookup_values flvt2,
852: fnd_lookup_values flvt3
853: WHERE (
854: ( disp.disposition_id = assoc.disposition_id
855: and assoc.workorder_mtl_txn_id = p_mtl_txn_id
856: )