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_REQUISITION_HEADERS_ALL

Line 1411: FROM zx_validation_errors_gt zxvegt, po_requisition_headers_all prh,

1407: ,null --distribution_id,
1408: ,null --distribution_num,
1409: ,zxvegt.message_text --message_text
1410: BULK COLLECT INTO G_TAX_ERRORS_TBL
1411: FROM zx_validation_errors_gt zxvegt, po_requisition_headers_all prh,
1412: po_requisition_lines_all prl
1413: WHERE zxvegt.trx_id = prh.requisition_header_id
1414: AND zxvegt.trx_line_id = prl.requisition_line_id(+);
1415:

Line 1522: FROM zx_errors_gt zxegt, po_requisition_headers_all prh,

1518: ,null --distribution_id,
1519: ,null --distribution_num,
1520: ,zxegt.message_text --message_text
1521: BULK COLLECT INTO G_TAX_ERRORS_TBL
1522: FROM zx_errors_gt zxegt, po_requisition_headers_all prh,
1523: po_requisition_lines_all prl
1524: WHERE zxegt.trx_id = prh.requisition_header_id
1525: AND zxegt.trx_line_id = prl.requisition_line_id(+);
1526:

Line 1623: FROM zx_errors_gt zxegt, po_requisition_headers_all prh,

1619: ,zxegt.trx_line_dist_id --distribution_id,
1620: ,prd.distribution_id --distribution_num,
1621: ,zxegt.message_text --message_text
1622: BULK COLLECT INTO G_TAX_ERRORS_TBL
1623: FROM zx_errors_gt zxegt, po_requisition_headers_all prh,
1624: po_requisition_lines_all prl, po_req_distributions_all prd
1625: WHERE zxegt.trx_id = prh.requisition_header_id
1626: AND zxegt.trx_line_id = prl.requisition_line_id(+)
1627: AND zxegt.trx_line_dist_id = prd.distribution_id(+);

Line 1678: FROM po_requisition_headers_all prh

1674: IF (l_line_count <> 0) THEN
1675: d_progress := 300;
1676: SELECT prh.org_id
1677: INTO l_org_id
1678: FROM po_requisition_headers_all prh
1679: WHERE prh.requisition_header_id=p_requisition_header_id;
1680:
1681: IF PO_LOG.d_stmt THEN
1682: PO_LOG.stmt(d_module_base,d_progress,'org_id = '||l_org_id);

Line 1741: update po_requisition_headers_all

1737: END IF; --IF (l_line_count <> 0)
1738:
1739: d_progress := 360;
1740: -- Null out tax_attribute_update_code columns
1741: update po_requisition_headers_all
1742: set tax_attribute_update_code = null
1743: where requisition_header_id = p_requisition_header_id;
1744:
1745: d_progress := 370;

Line 2400: FROM zx_errors_gt zxegt, po_requisition_headers_all prh,

2396: ,zxegt.trx_line_dist_id --distribution_id,
2397: ,prd.distribution_num --distribution_num,
2398: ,zxegt.message_text --message_text
2399: BULK COLLECT INTO G_TAX_ERRORS_TBL
2400: FROM zx_errors_gt zxegt, po_requisition_headers_all prh,
2401: po_requisition_lines_all prl, po_req_distributions_all prd
2402: WHERE zxegt.trx_id = prh.requisition_header_id
2403: AND zxegt.trx_line_id = prl.requisition_line_id(+)
2404: AND zxegt.trx_line_dist_id = prd.distribution_id(+);

Line 2987: FROM po_requisition_headers_all prh, zx_lines_det_factors zxldet

2983: ,zxldet.default_taxation_country --default_taxation_country
2984: ,DECODE(p_calling_program, --icx_session_id
2985: 'DETERMINE_RECOVERY_REQ', null,
2986: FND_GLOBAL.session_id)
2987: FROM po_requisition_headers_all prh, zx_lines_det_factors zxldet
2988: WHERE prh.requisition_header_id = p_requisition_header_id
2989: -- Conditions for getting Additional Tax Attributes
2990: -- Note that the req_header_id is of current document being processed,
2991: -- not of any source document. Get the first row obtained from join

Line 4355: po_requisition_headers_all prh, po_system_parameters_all psp

4351: -- this works for a requisition
4352: SELECT sob.currency_code, fsp.set_of_books_id, psp.default_rate_type
4353: INTO l_functional_currency_code, l_set_of_books_id, l_rate_type
4354: FROM financials_system_params_all fsp, gl_sets_of_books sob,
4355: po_requisition_headers_all prh, po_system_parameters_all psp
4356: WHERE fsp.set_of_books_id = sob.set_of_books_id
4357: AND fsp.org_id = prh.org_id
4358: AND prh.requisition_header_id = p_requisition_header_id
4359: AND psp.org_id = prh.org_id;

Line 4550: FROM po_requisition_headers_all prh, po_requisition_lines_all prl,

4546: ,Decode (p_calling_program,
4547: 'REQUISITION_MODIFY', zxldet.user_upd_det_factors_flag,
4548: 'REQIMPORT', NVL2(PRL.TAX_NAME,'Y',NULL))
4549: ,prl.destination_organization_id --Bug#6902111
4550: FROM po_requisition_headers_all prh, po_requisition_lines_all prl,
4551: zx_lines_det_factors zxldet, po_vendors pv, po_vendor_sites_all pvs,
4552: mtl_system_items_b msib, fnd_currencies fc
4553: WHERE prh.requisition_header_id = p_requisition_header_id
4554: AND prh.requisition_header_id = prl.requisition_header_id

Line 5170: FROM po_requisition_headers_all PRH,

5166: SELECT 'Y' INTO l_Result
5167: FROM DUAL
5168: WHERE EXISTS
5169: (SELECT 'Y'
5170: FROM po_requisition_headers_all PRH,
5171: po_requisition_lines_all PRL
5172: WHERE PRH.requisition_header_id = p_req_header_id
5173: AND PRH.requisition_header_id = PRL.requisition_header_id
5174: AND NVL(PRL.cancel_flag, 'N') = 'N'

Line 6602: l_header_tauc PO_REQUISITION_HEADERS_ALL.tax_attribute_update_code%TYPE;

6598: p_requisition_header_id IN NUMBER) IS
6599: d_module_base CONSTANT VARCHAR2(100) := p_module_base;
6600: d_progress NUMBER := p_progress;
6601: l_line_id_tbl PO_TBL_NUMBER;
6602: l_header_tauc PO_REQUISITION_HEADERS_ALL.tax_attribute_update_code%TYPE;
6603: l_line_tauc_tbl PO_TBL_VARCHAR15;
6604: BEGIN
6605:
6606: SELECT prh.tax_attribute_update_code

Line 6608: FROM po_requisition_headers_all prh

6604: BEGIN
6605:
6606: SELECT prh.tax_attribute_update_code
6607: INTO l_header_tauc
6608: FROM po_requisition_headers_all prh
6609: WHERE prh.requisition_header_id = p_requisition_header_id;
6610:
6611: PO_LOG.stmt(d_module_base,d_progress,' requisition_header_id = '||p_requisition_header_id||':'||l_header_tauc);
6612: