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.AP_APPROVAL_MATCHED_PKG dependencies on STANDARD

Line 1898: decode(PH.type_lookup_code, 'STANDARD', 'PO', 'RELEASE'),

1894: PLL.approved_flag,
1895: PLL.closed_code,
1896: decode(PLL.final_match_flag, 'Y', 'D', nvl(L.final_match_flag, 'N')), --Bug 3489536
1897: nvl(L.final_match_flag, 'N'),--Bug 5759169
1898: decode(PH.type_lookup_code, 'STANDARD', 'PO', 'RELEASE'),
1899: decode(L.po_release_id, null, PH.type_lookup_code, PR.release_type),
1900: nvl(PLL.accrue_on_receipt_flag, 'N'),
1901: DECODE(L.po_release_id, null, L.po_header_id, L.po_release_id),
1902: PH.segment1,

Line 1975: decode(PH.type_lookup_code, 'STANDARD', 'PO', 'RELEASE'),

1971: PLL.approved_flag, PLL.closed_code,
1972: decode(PLL.final_match_flag, 'Y', 'D', nvl(L.final_match_flag, 'N')), --Bug 3489536
1973: nvl(L.final_match_flag, 'N'),--Bug 5759169
1974: PLL.accrue_on_receipt_flag,
1975: decode(PH.type_lookup_code, 'STANDARD', 'PO', 'RELEASE'),
1976: DECODE(L.po_release_id, null, L.po_header_id, L.po_release_id),
1977: decode(L.po_release_id, null, PH.type_lookup_code, PR.release_type),
1978: PH.segment1, L.unit_meas_lookup_code,RSL.item_id,
1979: decode(PLL.unit_meas_lookup_code,null,PL.unit_meas_lookup_code,PLL.unit_meas_lookup_code), -- BUG 4184044

Line 3689: DECODE(PH.type_lookup_code, 'STANDARD', 'PO', 'RELEASE'),

3685: CURSOR Final_Match_Cur IS
3686: SELECT PLL.line_location_id,
3687: PLL.po_line_id,
3688: ROUND(NVL(PLL.quantity_received, 0), 5),
3689: DECODE(PH.type_lookup_code, 'STANDARD', 'PO', 'RELEASE'),
3690: DECODE(PD.po_release_id, NULL, PH.type_lookup_code,
3691: PR.release_type),
3692: NVL(PLL.accrue_on_receipt_flag, 'N'),
3693: DECODE(PD.po_release_id, NULL, PD.po_header_id,

Line 3713: DECODE(PH.type_lookup_code, 'STANDARD', 'PO', 'RELEASE'),

3709: -- Bug 5441016. made the last condition to be = , was <> before
3710: GROUP BY PLL.line_location_id,
3711: PLL.po_line_id,
3712: ROUND(NVL(PLL.quantity_received, 0), 5),
3713: DECODE(PH.type_lookup_code, 'STANDARD', 'PO', 'RELEASE'),
3714: DECODE(PD.po_release_id, NULL, PH.type_lookup_code,
3715: PR.release_type),
3716: NVL(PLL.accrue_on_receipt_flag, 'N'),
3717: DECODE(PD.po_release_id, NULL, PD.po_header_id,