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 1242: FROM zx_validation_errors_gt zxvegt, po_requisition_headers_all prh,

1238: ,null --distribution_id,
1239: ,null --distribution_num,
1240: ,zxvegt.message_text --message_text
1241: BULK COLLECT INTO G_TAX_ERRORS_TBL
1242: FROM zx_validation_errors_gt zxvegt, po_requisition_headers_all prh,
1243: po_requisition_lines_all prl
1244: WHERE zxvegt.trx_id = prh.requisition_header_id
1245: AND zxvegt.trx_line_id = prl.requisition_line_id(+);
1246:

Line 1353: FROM zx_errors_gt zxegt, po_requisition_headers_all prh,

1349: ,null --distribution_id,
1350: ,null --distribution_num,
1351: ,zxegt.message_text --message_text
1352: BULK COLLECT INTO G_TAX_ERRORS_TBL
1353: FROM zx_errors_gt zxegt, po_requisition_headers_all prh,
1354: po_requisition_lines_all prl
1355: WHERE zxegt.trx_id = prh.requisition_header_id
1356: AND zxegt.trx_line_id = prl.requisition_line_id(+);
1357:

Line 1454: FROM zx_errors_gt zxegt, po_requisition_headers_all prh,

1450: ,zxegt.trx_line_dist_id --distribution_id,
1451: ,prd.distribution_id --distribution_num,
1452: ,zxegt.message_text --message_text
1453: BULK COLLECT INTO G_TAX_ERRORS_TBL
1454: FROM zx_errors_gt zxegt, po_requisition_headers_all prh,
1455: po_requisition_lines_all prl, po_req_distributions_all prd
1456: WHERE zxegt.trx_id = prh.requisition_header_id
1457: AND zxegt.trx_line_id = prl.requisition_line_id(+)
1458: AND zxegt.trx_line_dist_id = prd.distribution_id(+);

Line 1509: FROM po_requisition_headers_all prh

1505: IF (l_line_count <> 0) THEN
1506: d_progress := 300;
1507: SELECT prh.org_id
1508: INTO l_org_id
1509: FROM po_requisition_headers_all prh
1510: WHERE prh.requisition_header_id=p_requisition_header_id;
1511:
1512: IF PO_LOG.d_stmt THEN
1513: PO_LOG.stmt(d_module_base,d_progress,'org_id = '||l_org_id);

Line 1572: update po_requisition_headers_all

1568: END IF; --IF (l_line_count <> 0)
1569:
1570: d_progress := 360;
1571: -- Null out tax_attribute_update_code columns
1572: update po_requisition_headers_all
1573: set tax_attribute_update_code = null
1574: where requisition_header_id = p_requisition_header_id;
1575:
1576: d_progress := 370;

Line 2215: FROM zx_errors_gt zxegt, po_requisition_headers_all prh,

2211: ,zxegt.trx_line_dist_id --distribution_id,
2212: ,prd.distribution_num --distribution_num,
2213: ,zxegt.message_text --message_text
2214: BULK COLLECT INTO G_TAX_ERRORS_TBL
2215: FROM zx_errors_gt zxegt, po_requisition_headers_all prh,
2216: po_requisition_lines_all prl, po_req_distributions_all prd
2217: WHERE zxegt.trx_id = prh.requisition_header_id
2218: AND zxegt.trx_line_id = prl.requisition_line_id(+)
2219: AND zxegt.trx_line_dist_id = prd.distribution_id(+);

Line 2802: FROM po_requisition_headers_all prh, zx_lines_det_factors zxldet

2798: ,zxldet.default_taxation_country --default_taxation_country
2799: ,DECODE(p_calling_program, --icx_session_id
2800: 'DETERMINE_RECOVERY_REQ', null,
2801: FND_GLOBAL.session_id)
2802: FROM po_requisition_headers_all prh, zx_lines_det_factors zxldet
2803: WHERE prh.requisition_header_id = p_requisition_header_id
2804: -- Conditions for getting Additional Tax Attributes
2805: -- Note that the req_header_id is of current document being processed,
2806: -- not of any source document. Get the first row obtained from join

Line 3478: po_requisition_headers_all prh, po_system_parameters_all psp

3474: -- this works for a requisition
3475: SELECT sob.currency_code, fsp.set_of_books_id, psp.default_rate_type
3476: INTO l_functional_currency_code, l_set_of_books_id, l_rate_type
3477: FROM financials_system_params_all fsp, gl_sets_of_books sob,
3478: po_requisition_headers_all prh, po_system_parameters_all psp
3479: WHERE fsp.set_of_books_id = sob.set_of_books_id
3480: AND fsp.org_id = prh.org_id
3481: AND prh.requisition_header_id = p_requisition_header_id
3482: AND psp.org_id = prh.org_id;

Line 3666: FROM po_requisition_headers_all prh, po_requisition_lines_all prl,

3662: ,(SELECT 'Y' FROM DUAL --user_upd_det_factors_flag
3663: WHERE p_calling_program = 'REQIMPORT'
3664: AND prl.tax_name IS NOT NULL)
3665: ,prl.destination_organization_id --Bug#6902111
3666: FROM po_requisition_headers_all prh, po_requisition_lines_all prl,
3667: zx_lines_det_factors zxldet, po_vendors pv, po_vendor_sites_all pvs,
3668: mtl_system_items_b msib, fnd_currencies fc
3669: WHERE prh.requisition_header_id = p_requisition_header_id
3670: AND prh.requisition_header_id = prl.requisition_header_id

Line 4277: FROM po_requisition_headers_all PRH,

4273: SELECT 'Y' INTO l_Result
4274: FROM DUAL
4275: WHERE EXISTS
4276: (SELECT 'Y'
4277: FROM po_requisition_headers_all PRH,
4278: po_requisition_lines_all PRL
4279: WHERE PRH.requisition_header_id = p_req_header_id
4280: AND PRH.requisition_header_id = PRL.requisition_header_id
4281: AND NVL(PRL.cancel_flag, 'N') = 'N'

Line 5706: l_header_tauc PO_REQUISITION_HEADERS_ALL.tax_attribute_update_code%TYPE;

5702: p_requisition_header_id IN NUMBER) IS
5703: d_module_base CONSTANT VARCHAR2(100) := p_module_base;
5704: d_progress NUMBER := p_progress;
5705: l_line_id_tbl PO_TBL_NUMBER;
5706: l_header_tauc PO_REQUISITION_HEADERS_ALL.tax_attribute_update_code%TYPE;
5707: l_line_tauc_tbl PO_TBL_VARCHAR15;
5708: BEGIN
5709:
5710: SELECT prh.tax_attribute_update_code

Line 5712: FROM po_requisition_headers_all prh

5708: BEGIN
5709:
5710: SELECT prh.tax_attribute_update_code
5711: INTO l_header_tauc
5712: FROM po_requisition_headers_all prh
5713: WHERE prh.requisition_header_id = p_requisition_header_id;
5714:
5715: PO_LOG.stmt(d_module_base,d_progress,' requisition_header_id = '||p_requisition_header_id||':'||l_header_tauc);
5716: