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_LINES_ALL

Line 1092: -- PO_REQUISITION_LINES_ALL.tax_attribute_update_code

1088: --Pre-reqs:
1089: -- Should be called when transaction data has been posted to the database
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:

Line 1093: -- PO_REQUISITION_LINES_ALL.original_shipment_id

1089: -- Should be called when transaction data has been posted to the database
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

Line 1243: po_requisition_lines_all prl

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:
1247: d_progress := 110;

Line 1298: FROM po_requisition_lines_all prl

1294: SET zxlgt.product_type =
1295: (SELECT DECODE(prl.purchase_basis,
1296: 'GOODS', 'GOODS',
1297: 'SERVICES')
1298: FROM po_requisition_lines_all prl
1299: WHERE prl.requisition_line_id = zxlgt.trx_line_id)
1300: WHERE zxlgt.product_type IS NULL
1301: AND zxlgt.line_level_action = 'CREATE';
1302:

Line 1354: po_requisition_lines_all prl

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:
1358: BEGIN

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 1577: update po_requisition_lines_all

1573: set tax_attribute_update_code = null
1574: where requisition_header_id = p_requisition_header_id;
1575:
1576: d_progress := 370;
1577: update po_requisition_lines_all
1578: set tax_attribute_update_code = null
1579: where requisition_header_id = p_requisition_header_id;
1580:
1581: -- Bug 5363122. Wipe out ZX GT tables at the end of tax call

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 3050: po_requisition_lines_all

3046: WHERE source_shipment.line_location_id = pll.original_shipment_id
3047: AND p_calling_program = 'COPY_DOCUMENT'),
3048:
3049: 'POXBWVRP_PO', (SELECT requisition_header_id FROM
3050: po_requisition_lines_all
3051: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3052: FROM po_requisition_lines_all prl
3053: WHERE prl.line_location_id = pll.line_location_id)
3054: AND p_calling_program = 'POXBWVRP_PO'),

Line 3052: FROM po_requisition_lines_all prl

3048:
3049: 'POXBWVRP_PO', (SELECT requisition_header_id FROM
3050: po_requisition_lines_all
3051: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3052: FROM po_requisition_lines_all prl
3053: WHERE prl.line_location_id = pll.line_location_id)
3054: AND p_calling_program = 'POXBWVRP_PO'),
3055: 'AUTOCREATED_DOC_WF', (SELECT requisition_header_id FROM
3056: po_requisition_lines_all

Line 3056: po_requisition_lines_all

3052: FROM po_requisition_lines_all prl
3053: WHERE prl.line_location_id = pll.line_location_id)
3054: AND p_calling_program = 'POXBWVRP_PO'),
3055: 'AUTOCREATED_DOC_WF', (SELECT requisition_header_id FROM
3056: po_requisition_lines_all
3057: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3058: FROM po_requisition_lines_all prl
3059: WHERE prl.line_location_id = pll.line_location_id)
3060: AND p_calling_program = 'AUTOCREATED_DOC_WF'),

Line 3058: FROM po_requisition_lines_all prl

3054: AND p_calling_program = 'POXBWVRP_PO'),
3055: 'AUTOCREATED_DOC_WF', (SELECT requisition_header_id FROM
3056: po_requisition_lines_all
3057: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3058: FROM po_requisition_lines_all prl
3059: WHERE prl.line_location_id = pll.line_location_id)
3060: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
3061: 'PORELGEB', (SELECT requisition_header_id FROM
3062: po_requisition_lines_all

Line 3062: po_requisition_lines_all

3058: FROM po_requisition_lines_all prl
3059: WHERE prl.line_location_id = pll.line_location_id)
3060: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
3061: 'PORELGEB', (SELECT requisition_header_id FROM
3062: po_requisition_lines_all
3063: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3064: FROM po_requisition_lines_all prl
3065: WHERE prl.line_location_id = pll.line_location_id)
3066: AND p_calling_program = 'PORELGEB'),

Line 3064: FROM po_requisition_lines_all prl

3060: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
3061: 'PORELGEB', (SELECT requisition_header_id FROM
3062: po_requisition_lines_all
3063: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3064: FROM po_requisition_lines_all prl
3065: WHERE prl.line_location_id = pll.line_location_id)
3066: AND p_calling_program = 'PORELGEB'),
3067: null)
3068: ,DECODE(p_calling_program, --source_line_id

Line 3071: FROM po_requisition_lines_all prl

3067: null)
3068: ,DECODE(p_calling_program, --source_line_id
3069: 'COPY_DOCUMENT', pll.original_shipment_id,
3070: 'POXBWVRP_PO',(SELECT Min(requisition_line_id) --source_line_id
3071: FROM po_requisition_lines_all prl
3072: WHERE prl.line_location_id = pll.line_location_id
3073: AND p_calling_program = 'POXBWVRP_PO'),
3074: 'AUTOCREATED_DOC_WF',(SELECT Min(requisition_line_id) --source_line_id
3075: FROM po_requisition_lines_all prl

Line 3075: FROM po_requisition_lines_all prl

3071: FROM po_requisition_lines_all prl
3072: WHERE prl.line_location_id = pll.line_location_id
3073: AND p_calling_program = 'POXBWVRP_PO'),
3074: 'AUTOCREATED_DOC_WF',(SELECT Min(requisition_line_id) --source_line_id
3075: FROM po_requisition_lines_all prl
3076: WHERE prl.line_location_id = pll.line_location_id
3077: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
3078: 'PORELGEB',(SELECT Min(requisition_line_id) --source_line_id
3079: FROM po_requisition_lines_all prl

Line 3079: FROM po_requisition_lines_all prl

3075: FROM po_requisition_lines_all prl
3076: WHERE prl.line_location_id = pll.line_location_id
3077: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
3078: 'PORELGEB',(SELECT Min(requisition_line_id) --source_line_id
3079: FROM po_requisition_lines_all prl
3080: WHERE prl.line_location_id = pll.line_location_id
3081: AND p_calling_program = 'PORELGEB'),
3082: null)
3083: ,DECODE(p_calling_program, --source_trx_level_type

Line 3343: po_requisition_lines_all

3339: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3340: null)
3341: ,DECODE(p_calling_program, -- source_trx_id
3342: 'POXBWVRP_PO', (SELECT requisition_header_id FROM
3343: po_requisition_lines_all
3344: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3345: FROM po_requisition_lines_all prl
3346: WHERE prl.line_location_id = pll.line_location_id)
3347: AND p_calling_program = 'POXBWVRP_PO'),

Line 3345: FROM po_requisition_lines_all prl

3341: ,DECODE(p_calling_program, -- source_trx_id
3342: 'POXBWVRP_PO', (SELECT requisition_header_id FROM
3343: po_requisition_lines_all
3344: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3345: FROM po_requisition_lines_all prl
3346: WHERE prl.line_location_id = pll.line_location_id)
3347: AND p_calling_program = 'POXBWVRP_PO'),
3348: 'AUTOCREATED_DOC_WF', (SELECT requisition_header_id FROM
3349: po_requisition_lines_all

Line 3349: po_requisition_lines_all

3345: FROM po_requisition_lines_all prl
3346: WHERE prl.line_location_id = pll.line_location_id)
3347: AND p_calling_program = 'POXBWVRP_PO'),
3348: 'AUTOCREATED_DOC_WF', (SELECT requisition_header_id FROM
3349: po_requisition_lines_all
3350: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3351: FROM po_requisition_lines_all prl
3352: WHERE prl.line_location_id = pll.line_location_id)
3353: AND p_calling_program = 'AUTOCREATED_DOC_WF'),

Line 3351: FROM po_requisition_lines_all prl

3347: AND p_calling_program = 'POXBWVRP_PO'),
3348: 'AUTOCREATED_DOC_WF', (SELECT requisition_header_id FROM
3349: po_requisition_lines_all
3350: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3351: FROM po_requisition_lines_all prl
3352: WHERE prl.line_location_id = pll.line_location_id)
3353: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
3354: 'PORELGEB', (SELECT requisition_header_id FROM
3355: po_requisition_lines_all

Line 3355: po_requisition_lines_all

3351: FROM po_requisition_lines_all prl
3352: WHERE prl.line_location_id = pll.line_location_id)
3353: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
3354: 'PORELGEB', (SELECT requisition_header_id FROM
3355: po_requisition_lines_all
3356: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3357: FROM po_requisition_lines_all prl
3358: WHERE prl.line_location_id = pll.line_location_id)
3359: AND p_calling_program = 'PORELGEB'),

Line 3357: FROM po_requisition_lines_all prl

3353: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
3354: 'PORELGEB', (SELECT requisition_header_id FROM
3355: po_requisition_lines_all
3356: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3357: FROM po_requisition_lines_all prl
3358: WHERE prl.line_location_id = pll.line_location_id)
3359: AND p_calling_program = 'PORELGEB'),
3360: null)
3361: ,DECODE(p_calling_program, --source_line_id

Line 3363: FROM po_requisition_lines_all prl

3359: AND p_calling_program = 'PORELGEB'),
3360: null)
3361: ,DECODE(p_calling_program, --source_line_id
3362: 'POXBWVRP_PO',(SELECT Min(requisition_line_id) --source_line_id
3363: FROM po_requisition_lines_all prl
3364: WHERE prl.line_location_id = pll.line_location_id
3365: AND p_calling_program = 'POXBWVRP_PO'),
3366: 'AUTOCREATED_DOC_WF',(SELECT Min(requisition_line_id) --source_line_id
3367: FROM po_requisition_lines_all prl

Line 3367: FROM po_requisition_lines_all prl

3363: FROM po_requisition_lines_all prl
3364: WHERE prl.line_location_id = pll.line_location_id
3365: AND p_calling_program = 'POXBWVRP_PO'),
3366: 'AUTOCREATED_DOC_WF',(SELECT Min(requisition_line_id) --source_line_id
3367: FROM po_requisition_lines_all prl
3368: WHERE prl.line_location_id = pll.line_location_id
3369: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
3370: 'PORELGEB',(SELECT Min(requisition_line_id) --source_line_id
3371: FROM po_requisition_lines_all prl

Line 3371: FROM po_requisition_lines_all prl

3367: FROM po_requisition_lines_all prl
3368: WHERE prl.line_location_id = pll.line_location_id
3369: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
3370: 'PORELGEB',(SELECT Min(requisition_line_id) --source_line_id
3371: FROM po_requisition_lines_all prl
3372: WHERE prl.line_location_id = pll.line_location_id
3373: AND p_calling_program = 'PORELGEB'),
3374: null)
3375: ,DECODE(p_calling_program, --source_trx_level_type

Line 3466: l_functional_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;

3462: -----------------------------------------------------------------------------
3463: PROCEDURE populate_zx_lines_with_req(p_requisition_header_id IN NUMBER,
3464: p_calling_program IN VARCHAR2
3465: ) IS
3466: l_functional_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
3467: l_set_of_books_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;
3468: l_rate_type PO_REQUISITION_LINES_ALL.rate_type%TYPE;
3469: l_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
3470: BEGIN

Line 3468: l_rate_type PO_REQUISITION_LINES_ALL.rate_type%TYPE;

3464: p_calling_program IN VARCHAR2
3465: ) IS
3466: l_functional_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
3467: l_set_of_books_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;
3468: l_rate_type PO_REQUISITION_LINES_ALL.rate_type%TYPE;
3469: l_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
3470: BEGIN
3471:
3472: -- Get the requisition's functional currency info.

Line 3469: l_rate PO_REQUISITION_LINES_ALL.rate%TYPE;

3465: ) IS
3466: l_functional_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
3467: l_set_of_books_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;
3468: l_rate_type PO_REQUISITION_LINES_ALL.rate_type%TYPE;
3469: l_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
3470: BEGIN
3471:
3472: -- Get the requisition's functional currency info.
3473: -- This piece of code is similar to PO_GA_PVT.get_currency_info except that

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 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'

Line 4278: po_requisition_lines_all PRL

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'
4282: AND NVL(PRL.closed_code, 'OPEN') <> 'FINALLY CLOSED'

Line 5720: FROM po_requisition_lines_all prl

5716:
5717: l_line_id_tbl := null; l_line_tauc_tbl := null;
5718: SELECT prl.requisition_line_id, prl.tax_attribute_update_code
5719: BULK COLLECT INTO l_line_id_tbl, l_line_tauc_tbl
5720: FROM po_requisition_lines_all prl
5721: WHERE prl.requisition_header_id = p_requisition_header_id;
5722:
5723: FOR i IN 1..l_line_id_tbl.COUNT LOOP
5724: PO_LOG.stmt(d_module_base,d_progress,' requisition_line_id = '||l_line_id_tbl(i)||':'||l_line_tauc_tbl(i));