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 1094: -- PO_REQ_DISTRIBUTIONS_ALL.nonrecoverable_tax

1090: -- but not yet committed
1091: --Modifies:
1092: -- PO_REQUISITION_LINES_ALL.tax_attribute_update_code
1093: -- PO_REQUISITION_LINES_ALL.original_shipment_id
1094: -- PO_REQ_DISTRIBUTIONS_ALL.nonrecoverable_tax
1095: -- PO_REQ_DISTRIBUTIONS_ALL.recoverable_tax
1096: --Locks:
1097: -- Transaction tables if update is allowed
1098: --Function:

Line 1095: -- PO_REQ_DISTRIBUTIONS_ALL.recoverable_tax

1091: --Modifies:
1092: -- PO_REQUISITION_LINES_ALL.tax_attribute_update_code
1093: -- PO_REQUISITION_LINES_ALL.original_shipment_id
1094: -- PO_REQ_DISTRIBUTIONS_ALL.nonrecoverable_tax
1095: -- PO_REQ_DISTRIBUTIONS_ALL.recoverable_tax
1096: --Locks:
1097: -- Transaction tables if update is allowed
1098: --Function:
1099: -- Calculate tax amounts for the requisition passed in

Line 1455: po_requisition_lines_all prl, po_req_distributions_all prd

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

Line 1481: UPDATE po_req_distributions_all prd

1477: END IF;
1478:
1479: d_progress := 290;
1480: -- Populate recoverable/nonrecoverable tax columns in distributions table
1481: UPDATE po_req_distributions_all prd
1482: SET prd.recoverable_tax =
1483: (SELECT SUM(zxdist.rec_nrec_tax_amt)
1484: FROM zx_rec_nrec_dist_gt zxdist
1485: WHERE zxdist.trx_line_dist_id = prd.distribution_id

Line 2101: -- PO_REQ_DISTRIBUTIONS_ALL.nonrecoverable_tax

2097: --Name: determine_recovery_req
2098: --Pre-reqs:
2099: -- None
2100: --Modifies:
2101: -- PO_REQ_DISTRIBUTIONS_ALL.nonrecoverable_tax
2102: -- PO_REQ_DISTRIBUTIONS_ALL.recoverable_tax
2103: --Locks:
2104: -- Transaction tables if update is allowed
2105: --Function:

Line 2102: -- PO_REQ_DISTRIBUTIONS_ALL.recoverable_tax

2098: --Pre-reqs:
2099: -- None
2100: --Modifies:
2101: -- PO_REQ_DISTRIBUTIONS_ALL.nonrecoverable_tax
2102: -- PO_REQ_DISTRIBUTIONS_ALL.recoverable_tax
2103: --Locks:
2104: -- Transaction tables if update is allowed
2105: --Function:
2106: -- Distributes tax lines and calculates_recoverable and nonrecoverable tax

Line 2216: po_requisition_lines_all prl, po_req_distributions_all prd

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

Line 2240: UPDATE po_req_distributions_all prd

2236: END IF;
2237:
2238: d_progress := 50;
2239: -- Populate recoverable/nonrecoverable tax columns in distributions table
2240: UPDATE po_req_distributions_all prd
2241: SET prd.recoverable_tax =
2242: (SELECT SUM(zxdist.rec_nrec_tax_amt)
2243: FROM zx_rec_nrec_dist_gt zxdist
2244: WHERE zxdist.trx_line_dist_id = prd.distribution_id

Line 3649: FROM po_req_distributions_all prd

3645: )
3646: -- Get account id from first distribution, if created
3647: -- otherwise from the expense account of the item
3648: ,NVL((SELECT prd.code_combination_id --account_ccid
3649: FROM po_req_distributions_all prd
3650: WHERE prd.requisition_line_id = prl.requisition_line_id
3651: AND rownum = 1),
3652: msib.expense_account
3653: )

Line 4151: FROM po_requisition_lines_all prl, po_req_distributions_all prd

4147: ,prl.quantity --trx_line_quantity
4148: ,prd.code_combination_id --account_ccid
4149: ,null --historical_flag
4150: ,decode(prd.tax_recovery_override_flag, 'Y', prd.recovery_rate, null) --overriding_recovery_rate
4151: FROM po_requisition_lines_all prl, po_req_distributions_all prd
4152: WHERE prl.requisition_header_id = p_requisition_header_id
4153: AND prl.requisition_line_id = prd.requisition_line_id
4154: -- Conditions that determine that requisition line is 'Active'
4155: AND prl.SOURCE_TYPE_CODE<>'INVENTORY'