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.JAI_PO_WF_UTIL_PUB dependencies on JAI_PO_TAXES

Line 484: lv_po_tax_currency JAI_PO_TAXES.currency%TYPE;

480: ln_total_nr_tax_amount NUMBER :=0;
481: ln_currency_rate NUMBER;
482: ln_req_line_id JAI_PO_REQ_LINE_TAXES.requisition_line_id%TYPE;
483: lv_req_tax_currency JAI_PO_REQ_LINE_TAXES.currency%TYPE;
484: lv_po_tax_currency JAI_PO_TAXES.currency%TYPE;
485: lv_rel_tax_currency JAI_PO_TAXES.currency%TYPE;
486: lv_modvat_flag VARCHAR2(1); --add by Xiao Lv for IL po notification on Mar-25-2009
487: ln_po_header_id PO_RELEASES_ALL.PO_HEADER_ID%TYPE;
488: lv_tax_type jai_cmn_taxes_all.tax_type%TYPE; -- added by Eric Ma for bug10426971 on 28-Dec-2010

Line 485: lv_rel_tax_currency JAI_PO_TAXES.currency%TYPE;

481: ln_currency_rate NUMBER;
482: ln_req_line_id JAI_PO_REQ_LINE_TAXES.requisition_line_id%TYPE;
483: lv_req_tax_currency JAI_PO_REQ_LINE_TAXES.currency%TYPE;
484: lv_po_tax_currency JAI_PO_TAXES.currency%TYPE;
485: lv_rel_tax_currency JAI_PO_TAXES.currency%TYPE;
486: lv_modvat_flag VARCHAR2(1); --add by Xiao Lv for IL po notification on Mar-25-2009
487: ln_po_header_id PO_RELEASES_ALL.PO_HEADER_ID%TYPE;
488: lv_tax_type jai_cmn_taxes_all.tax_type%TYPE; -- added by Eric Ma for bug10426971 on 28-Dec-2010
489:

Line 512: JAI_PO_TAXES

508: , NVL(tax_amount, 0)
509: , currency
510: , NVL(modvat_flag,'N') --add by Xiao Lv for IL po notification on Mar-25-2009
511: FROM
512: JAI_PO_TAXES
513: WHERE PO_HEADER_ID = pn_document_id;
514:
515:
516: CURSOR Get_Rel_tax_Cur

Line 525: , JAI_PO_TAXES JPT

521: , JPT.currency
522: , NVL(JPT.modvat_flag,'N') --add by Xiao Lv for IL po notification on Mar-25-2009
523: FROM
524: PO_LINE_LOCATIONS_ALL PLLA
525: , JAI_PO_TAXES JPT
526: WHERE PLLA.LINE_LOCATION_ID = JPT.LINE_LOCATION_ID
527: AND PLLA.PO_RELEASE_ID = pn_document_id;
528:
529:

Line 1308: lv_po_tax_currency JAI_PO_TAXES.currency%TYPE;

1304: ln_total_nr_tax_amount NUMBER :=0;
1305: ln_currency_rate NUMBER;
1306: ln_req_line_id JAI_PO_REQ_LINE_TAXES.requisition_line_id%TYPE;
1307: lv_req_tax_currency JAI_PO_REQ_LINE_TAXES.currency%TYPE;
1308: lv_po_tax_currency JAI_PO_TAXES.currency%TYPE;
1309: lv_rel_tax_currency JAI_PO_TAXES.currency%TYPE;
1310: lv_modvat_flag VARCHAR2(1);
1311: lv_tax_type jai_cmn_taxes_all.tax_type%TYPE; -- added by Eric Ma for bug10426971 on 28-Dec-2010
1312:

Line 1309: lv_rel_tax_currency JAI_PO_TAXES.currency%TYPE;

1305: ln_currency_rate NUMBER;
1306: ln_req_line_id JAI_PO_REQ_LINE_TAXES.requisition_line_id%TYPE;
1307: lv_req_tax_currency JAI_PO_REQ_LINE_TAXES.currency%TYPE;
1308: lv_po_tax_currency JAI_PO_TAXES.currency%TYPE;
1309: lv_rel_tax_currency JAI_PO_TAXES.currency%TYPE;
1310: lv_modvat_flag VARCHAR2(1);
1311: lv_tax_type jai_cmn_taxes_all.tax_type%TYPE; -- added by Eric Ma for bug10426971 on 28-Dec-2010
1312:
1313: CURSOR Get_Req_tax_Cur

Line 1335: JAI_PO_TAXES

1331: , tax_amount
1332: , currency
1333: , modvat_flag
1334: FROM
1335: JAI_PO_TAXES
1336: WHERE PO_HEADER_ID = pn_document_id
1337: AND po_line_id = NVL(pn_line_id, po_line_id)
1338: And line_location_id = NVL(pn_line_location_id, line_location_id);
1339:

Line 1351: , JAI_PO_TAXES JPT

1347: , JPT.modvat_flag
1348: FROM
1349: PO_RELEASES_ALL POA
1350: , PO_LINE_LOCATIONS_ALL PLLA
1351: , JAI_PO_TAXES JPT
1352: WHERE PLLA.LINE_LOCATION_ID = JPT.LINE_LOCATION_ID
1353: AND POA.PO_HEADER_ID = PLLA.PO_HEADER_ID
1354: AND POA.PO_RELEASE_ID = PLLA.PO_RELEASE_ID
1355: AND POA.RELEASE_NUM = pn_release_num