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 2126: decode(PH.type_lookup_code, 'STANDARD', 'PO', 'RELEASE'),

2122: PLL.approved_flag,
2123: PLL.closed_code,
2124: decode(PLL.final_match_flag, 'Y', 'D', nvl(L.final_match_flag, 'N')), --Bug 3489536
2125: nvl(L.final_match_flag, 'N'),--Bug 5759169
2126: decode(PH.type_lookup_code, 'STANDARD', 'PO', 'RELEASE'),
2127: decode(L.po_release_id, null, PH.type_lookup_code, PR.release_type),
2128: nvl(PLL.accrue_on_receipt_flag, 'N'),
2129: DECODE(L.po_release_id, null, L.po_header_id, L.po_release_id),
2130: PH.segment1,

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

2199: PLL.approved_flag, PLL.closed_code,
2200: decode(PLL.final_match_flag, 'Y', 'D', nvl(L.final_match_flag, 'N')), --Bug 3489536
2201: nvl(L.final_match_flag, 'N'),--Bug 5759169
2202: PLL.accrue_on_receipt_flag,
2203: decode(PH.type_lookup_code, 'STANDARD', 'PO', 'RELEASE'),
2204: DECODE(L.po_release_id, null, L.po_header_id, L.po_release_id),
2205: decode(L.po_release_id, null, PH.type_lookup_code, PR.release_type),
2206: PH.segment1, L.unit_meas_lookup_code,RSL.item_id,
2207: decode(PLL.unit_meas_lookup_code,null,PL.unit_meas_lookup_code,PLL.unit_meas_lookup_code), -- BUG 4184044

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

4128: CURSOR Final_Match_Cur IS
4129: SELECT PLL.line_location_id,
4130: PLL.po_line_id,
4131: ROUND(NVL(PLL.quantity_received, 0), 5),
4132: DECODE(PH.type_lookup_code, 'STANDARD', 'PO', 'RELEASE'),
4133: DECODE(PD.po_release_id, NULL, PH.type_lookup_code,
4134: PR.release_type),
4135: NVL(PLL.accrue_on_receipt_flag, 'N'),
4136: DECODE(PD.po_release_id, NULL, PD.po_header_id,

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

4152: -- Bug 5441016. made the last condition to be = , was <> before
4153: GROUP BY PLL.line_location_id,
4154: PLL.po_line_id,
4155: ROUND(NVL(PLL.quantity_received, 0), 5),
4156: DECODE(PH.type_lookup_code, 'STANDARD', 'PO', 'RELEASE'),
4157: DECODE(PD.po_release_id, NULL, PH.type_lookup_code,
4158: PR.release_type),
4159: NVL(PLL.accrue_on_receipt_flag, 'N'),
4160: DECODE(PD.po_release_id, NULL, PD.po_header_id,