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_REQ_DISTRIBUTIONS_ALL

Line 1248: -- PO_REQ_DISTRIBUTIONS_ALL.nonrecoverable_tax

1244: -- but not yet committed
1245: --Modifies:
1246: -- PO_REQUISITION_LINES_ALL.tax_attribute_update_code
1247: -- PO_REQUISITION_LINES_ALL.original_shipment_id
1248: -- PO_REQ_DISTRIBUTIONS_ALL.nonrecoverable_tax
1249: -- PO_REQ_DISTRIBUTIONS_ALL.recoverable_tax
1250: --Locks:
1251: -- Transaction tables if update is allowed
1252: --Function:

Line 1249: -- PO_REQ_DISTRIBUTIONS_ALL.recoverable_tax

1245: --Modifies:
1246: -- PO_REQUISITION_LINES_ALL.tax_attribute_update_code
1247: -- PO_REQUISITION_LINES_ALL.original_shipment_id
1248: -- PO_REQ_DISTRIBUTIONS_ALL.nonrecoverable_tax
1249: -- PO_REQ_DISTRIBUTIONS_ALL.recoverable_tax
1250: --Locks:
1251: -- Transaction tables if update is allowed
1252: --Function:
1253: -- Calculate tax amounts for the requisition passed in

Line 1624: po_requisition_lines_all prl, po_req_distributions_all prd

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(+);
1628:

Line 1650: UPDATE po_req_distributions_all prd

1646: END IF;
1647:
1648: d_progress := 290;
1649: -- Populate recoverable/nonrecoverable tax columns in distributions table
1650: UPDATE po_req_distributions_all prd
1651: SET prd.recoverable_tax =
1652: (SELECT SUM(zxdist.rec_nrec_tax_amt)
1653: FROM zx_rec_nrec_dist_gt zxdist
1654: WHERE zxdist.trx_line_dist_id = prd.distribution_id

Line 2286: -- PO_REQ_DISTRIBUTIONS_ALL.nonrecoverable_tax

2282: --Name: determine_recovery_req
2283: --Pre-reqs:
2284: -- None
2285: --Modifies:
2286: -- PO_REQ_DISTRIBUTIONS_ALL.nonrecoverable_tax
2287: -- PO_REQ_DISTRIBUTIONS_ALL.recoverable_tax
2288: --Locks:
2289: -- Transaction tables if update is allowed
2290: --Function:

Line 2287: -- PO_REQ_DISTRIBUTIONS_ALL.recoverable_tax

2283: --Pre-reqs:
2284: -- None
2285: --Modifies:
2286: -- PO_REQ_DISTRIBUTIONS_ALL.nonrecoverable_tax
2287: -- PO_REQ_DISTRIBUTIONS_ALL.recoverable_tax
2288: --Locks:
2289: -- Transaction tables if update is allowed
2290: --Function:
2291: -- Distributes tax lines and calculates_recoverable and nonrecoverable tax

Line 2401: po_requisition_lines_all prl, po_req_distributions_all prd

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(+);
2405:

Line 2425: UPDATE po_req_distributions_all prd

2421: END IF;
2422:
2423: d_progress := 50;
2424: -- Populate recoverable/nonrecoverable tax columns in distributions table
2425: UPDATE po_req_distributions_all prd
2426: SET prd.recoverable_tax =
2427: (SELECT SUM(zxdist.rec_nrec_tax_amt)
2428: FROM zx_rec_nrec_dist_gt zxdist
2429: WHERE zxdist.trx_line_dist_id = prd.distribution_id

Line 4529: FROM po_req_distributions_all prd

4525: )
4526: -- Get account id from first distribution, if created
4527: -- otherwise from the expense account of the item
4528: ,NVL((SELECT prd.code_combination_id --account_ccid
4529: FROM po_req_distributions_all prd
4530: WHERE prd.requisition_line_id = prl.requisition_line_id
4531: AND rownum = 1),
4532: msib.expense_account
4533: )

Line 5044: FROM po_requisition_lines_all prl, po_req_distributions_all prd

5040: ,prl.quantity --trx_line_quantity
5041: ,prd.code_combination_id --account_ccid
5042: ,null --historical_flag
5043: ,decode(prd.tax_recovery_override_flag, 'Y', prd.recovery_rate, null) --overriding_recovery_rate
5044: FROM po_requisition_lines_all prl, po_req_distributions_all prd
5045: WHERE prl.requisition_header_id = p_requisition_header_id
5046: AND prl.requisition_line_id = prd.requisition_line_id
5047: -- Conditions that determine that requisition line is 'Active'
5048: AND prl.SOURCE_TYPE_CODE<>'INVENTORY'