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.PO_TAX_INTERFACE_PVT dependencies on PO_RELEASES_ALL

Line 244: FROM po_releases_all pr

240: FROM po_distributions_all pod
241: WHERE pod.tax_attribute_update_code = 'UPDATE'
242: AND pod.line_location_id = pll.line_location_id
243: AND ROWNUM = 1), pr.tax_attribute_update_code)
244: FROM po_releases_all pr
245: WHERE pll.po_release_id = pr.po_release_id
246: -- following AND written only for clarity
247: --AND ph.tax_attribute_update_code IS NOT NULL
248: )

Line 256: -- Replaced po_headers_all with po_releases_all for releases case.

252: pll.po_release_id = p_po_release_id_tbl(i)
253: AND (pll.tax_attribute_update_code IS NULL
254: OR pll.tax_attribute_update_code = 'DIST_DELETE');
255:
256: -- Replaced po_headers_all with po_releases_all for releases case.
257: -- End bug 13925912
258:
259: IF PO_LOG.d_stmt THEN
260: PO_LOG.stmt(d_module_base,d_progress,'tax_attribute_update_codes after denormalization');

Line 381: po_releases_all pr

377: ,zxvegt.message_text
378: ,'VALIDATE'
379: ,ph.segment1
380: FROM zx_validation_errors_gt zxvegt, po_headers_all ph,
381: po_releases_all pr
382: WHERE zxvegt.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
383: AND zxvegt.trx_id = pr.po_release_id
384: AND pr.po_header_id = ph.po_header_id;
385:

Line 564: FROM zx_errors_gt zxegt, po_headers_all ph, po_releases_all pr

560: ,zxegt.event_class_code
561: ,zxegt.message_text
562: ,'CALCULATE_TAX'
563: ,ph.segment1
564: FROM zx_errors_gt zxegt, po_headers_all ph, po_releases_all pr
565: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
566: AND zxegt.trx_id = pr.po_release_id
567: AND pr.po_header_id = ph.po_header_id;
568:

Line 756: FROM zx_errors_gt zxegt, po_headers_all ph, po_releases_all pr

752: ,zxegt.event_class_code
753: ,zxegt.message_text
754: ,'DETERMINE_RECOVERY'
755: ,ph.segment1
756: FROM zx_errors_gt zxegt, po_headers_all ph, po_releases_all pr
757: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
758: AND zxegt.trx_id = pr.po_release_id
759: AND pr.po_header_id = ph.po_header_id;
760:

Line 887: UPDATE po_releases_all pr

883: WHERE zxlgt.trx_id=ph.po_header_id);
884:
885: d_progress := 470;
886: FORALL i IN 1..p_po_release_id_tbl.COUNT
887: UPDATE po_releases_all pr
888: SET pr.tax_attribute_update_code = null
889: WHERE pr.po_release_id = p_po_release_id_tbl(i)
890: AND EXISTS (SELECT 'Y'
891: FROM zx_transaction_lines_gt zxlgt

Line 2177: FROM zx_errors_gt zxegt, po_releases_all pr, po_headers_all ph,

2173: ,zxegt.trx_line_dist_id --distribution_id,
2174: ,pd.distribution_num --distribution_num,
2175: ,zxegt.message_text --message_text
2176: BULK COLLECT INTO G_TAX_ERRORS_TBL
2177: FROM zx_errors_gt zxegt, po_releases_all pr, po_headers_all ph,
2178: po_line_locations_all pll, po_distributions_all pd
2179: WHERE zxegt.trx_id = pr.po_release_id
2180: AND pr.po_header_id = ph.po_header_id
2181: AND zxegt.trx_line_id = pll.line_location_id(+)

Line 2794: ,po_releases_all pr

2790: -- Using OUTER JOIN in FROM clause syntax here because (+) operator
2791: -- is not flexible enough to be used inside an OR condition
2792: FROM po_headers_all ph
2793: ,fnd_currencies fc
2794: ,po_releases_all pr
2795: -- Conditions for getting Additional Tax Attributes
2796: -- Copy from Planned PO if its a newly created Scheduled Release
2797: -- ELSE simply copy from existing release header (ie. in case of a
2798: -- shipment split or regular blanket/scheduled release create/update

Line 2913: FROM po_releases_all pr, po_headers_all ph, fnd_currencies fc

2909: -- Bug 5025018. Updated tax attribute mappings
2910: ,ph.org_id --rounding_bill_to_party_id
2911: ,(SELECT pvs.party_site_id from po_vendor_sites_all pvs --rndg_ship_from_party_site_id
2912: WHERE pvs.vendor_site_id=ph.vendor_site_id)
2913: FROM po_releases_all pr, po_headers_all ph, fnd_currencies fc
2914: WHERE pr.po_release_id = p_po_release_id
2915: AND pr.po_header_id = ph.po_header_id
2916: AND fc.currency_code = ph.currency_code;
2917:

Line 3600: FROM po_releases_all pr

3596: ,pll.ship_to_organization_id --ship_to_party_id
3597: ,pll.ship_to_organization_id --Bug#6902111
3598: -- Using OUTER JOIN in FROM clause syntax here because (+) operator
3599: -- is not flexible enough to be used inside an OR condition
3600: FROM po_releases_all pr
3601: ,po_headers_all ph
3602: -- Join with vendor tables to get party and party site information
3603: LEFT OUTER JOIN po_vendors pov ON (ph.vendor_id = pov.vendor_id)
3604: LEFT OUTER JOIN po_vendor_sites_all pvs

Line 4256: FROM po_releases_all pr

4252: ,pll.ship_to_organization_id --ship_to_party_id
4253: ,pll.ship_to_organization_id --Bug#6902111
4254: -- Using OUTER JOIN in FROM clause syntax here because (+) operator
4255: -- is not flexible enough to be used inside an OR condition
4256: FROM po_releases_all pr
4257: ,po_headers_all ph
4258: -- Join with vendor tables to get party and party site information
4259: LEFT OUTER JOIN po_vendors pov ON (ph.vendor_id = pov.vendor_id)
4260: LEFT OUTER JOIN po_vendor_sites_all pvs

Line 5149: FROM po_releases_all POR,

5145: SELECT 'Y' INTO l_Result
5146: FROM DUAL
5147: WHERE EXISTS
5148: (SELECT 'Y'
5149: FROM po_releases_all POR,
5150: po_line_locations_all PLL,
5151: po_distributions_all POD
5152: WHERE POR.po_release_id = p_po_release_id
5153: AND POR.po_release_id = PLL.po_release_id

Line 6528: l_header_tauc PO_RELEASES_ALL.tax_attribute_update_code%TYPE;

6524: d_module_base CONSTANT VARCHAR2(100) := p_module_base;
6525: d_progress NUMBER := p_progress;
6526: l_ship_id_tbl PO_TBL_NUMBER;
6527: l_dist_id_tbl PO_TBL_NUMBER;
6528: l_header_tauc PO_RELEASES_ALL.tax_attribute_update_code%TYPE;
6529: l_ship_tauc_tbl PO_TBL_VARCHAR15;
6530: l_dist_tauc_tbl PO_TBL_VARCHAR15;
6531: BEGIN
6532:

Line 6537: FROM po_releases_all pr

6533: FOR i IN 1..p_po_release_id_tbl.COUNT LOOP
6534:
6535: SELECT pr.tax_attribute_update_code
6536: INTO l_header_tauc
6537: FROM po_releases_all pr
6538: WHERE pr.po_release_id = p_po_release_id_tbl(i);
6539:
6540: PO_LOG.stmt(d_module_base,d_progress,' po_release_id = '||p_po_release_id_tbl(i)||':'||l_header_tauc);
6541:

Line 6970: FROM po_releases_all pr, po_headers_all ph

6966: sysdate, -- dummy value
6967: PO_CORE_S.get_default_legal_entity_id(pr.org_id),
6968: (SELECT party_id FROM po_vendors --rounding_ship_from_party_id
6969: WHERE vendor_id=ph.vendor_id)
6970: FROM po_releases_all pr, po_headers_all ph
6971: WHERE pr.po_release_id = p_document_id
6972: AND pr.po_header_id = ph.po_header_id;
6973:
6974: d_progress := 180;

Line 7032: FROM po_releases_all pr

7028: -- in Cancel mode
7029: d_progress := 220;
7030: SELECT pr.org_id
7031: INTO l_org_id
7032: FROM po_releases_all pr
7033: WHERE pr.po_release_id = p_document_id;
7034:
7035: d_progress := 230;
7036: IF (PO_LOG.d_stmt) THEN

Line 7222: -- PO_RELEASES_ALL.authorization_status

7218: -- None
7219: --Modifies:
7220: -- PO_HEADERS_ALL.authorization_status
7221: -- PO_HEADERS_ALL.approved_flag
7222: -- PO_RELEASES_ALL.authorization_status
7223: -- PO_RELEASES_ALL.approved_flag
7224: --Locks:
7225: -- PO_HEADERS_ALL
7226: -- PO_RELEASES_ALL

Line 7223: -- PO_RELEASES_ALL.approved_flag

7219: --Modifies:
7220: -- PO_HEADERS_ALL.authorization_status
7221: -- PO_HEADERS_ALL.approved_flag
7222: -- PO_RELEASES_ALL.authorization_status
7223: -- PO_RELEASES_ALL.approved_flag
7224: --Locks:
7225: -- PO_HEADERS_ALL
7226: -- PO_RELEASES_ALL
7227: --Function:

Line 7226: -- PO_RELEASES_ALL

7222: -- PO_RELEASES_ALL.authorization_status
7223: -- PO_RELEASES_ALL.approved_flag
7224: --Locks:
7225: -- PO_HEADERS_ALL
7226: -- PO_RELEASES_ALL
7227: --Function:
7228: -- Unapprove the header for the given document
7229: --Parameters:
7230: --IN:

Line 7277: FROM po_releases_all pr

7273: WHERE ph.po_header_id = p_document_id;
7274: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
7275: SELECT pr.authorization_status
7276: INTO l_authorization_status
7277: FROM po_releases_all pr
7278: WHERE pr.po_release_id = p_document_id;
7279: END IF;
7280:
7281: IF PO_LOG.d_stmt THEN

Line 7294: UPDATE po_releases_all pr

7290: SET ph.authorization_status = PO_CONSTANTS_SV.IN_PROCESS,
7291: ph.approved_flag = 'N'
7292: WHERE ph.po_header_id = p_document_id;
7293: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
7294: UPDATE po_releases_all pr
7295: SET pr.authorization_status = PO_CONSTANTS_SV.IN_PROCESS,
7296: pr.approved_flag = 'N'
7297: WHERE pr.po_release_id = p_document_id;
7298: END IF;

Line 7309: UPDATE po_releases_all pr

7305: SET ph.authorization_status = PO_CONSTANTS_SV.REQUIRES_REAPPROVAL,
7306: ph.approved_flag = 'R'
7307: WHERE ph.po_header_id = p_document_id;
7308: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
7309: UPDATE po_releases_all pr
7310: SET pr.authorization_status = PO_CONSTANTS_SV.REQUIRES_REAPPROVAL,
7311: pr.approved_flag = 'R'
7312: WHERE pr.po_release_id = p_document_id;
7313: END IF;