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 1246: -- PO_REQUISITION_LINES_ALL.tax_attribute_update_code

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

Line 1247: -- PO_REQUISITION_LINES_ALL.original_shipment_id

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

Line 1412: po_requisition_lines_all prl

1408: ,null --distribution_num,
1409: ,zxvegt.message_text --message_text
1410: BULK COLLECT INTO G_TAX_ERRORS_TBL
1411: FROM zx_validation_errors_gt zxvegt, po_requisition_headers_all prh,
1412: po_requisition_lines_all prl
1413: WHERE zxvegt.trx_id = prh.requisition_header_id
1414: AND zxvegt.trx_line_id = prl.requisition_line_id(+);
1415:
1416: d_progress := 110;

Line 1467: FROM po_requisition_lines_all prl

1463: SET zxlgt.product_type =
1464: (SELECT DECODE(prl.purchase_basis,
1465: 'GOODS', 'GOODS',
1466: 'SERVICES')
1467: FROM po_requisition_lines_all prl
1468: WHERE prl.requisition_line_id = zxlgt.trx_line_id)
1469: WHERE zxlgt.product_type IS NULL
1470: AND zxlgt.line_level_action = 'CREATE';
1471:

Line 1523: po_requisition_lines_all prl

1519: ,null --distribution_num,
1520: ,zxegt.message_text --message_text
1521: BULK COLLECT INTO G_TAX_ERRORS_TBL
1522: FROM zx_errors_gt zxegt, po_requisition_headers_all prh,
1523: po_requisition_lines_all prl
1524: WHERE zxegt.trx_id = prh.requisition_header_id
1525: AND zxegt.trx_line_id = prl.requisition_line_id(+);
1526:
1527: BEGIN

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

1742: set tax_attribute_update_code = null
1743: where requisition_header_id = p_requisition_header_id;
1744:
1745: d_progress := 370;
1746: update po_requisition_lines_all
1747: set tax_attribute_update_code = null
1748: where requisition_header_id = p_requisition_header_id;
1749:
1750: -- Bug 5363122. Wipe out ZX GT tables at the end of tax call

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

3237: WHERE source_shipment.line_location_id = pll.original_shipment_id
3238: AND p_calling_program = 'COPY_DOCUMENT'),
3239:
3240: 'POXBWVRP_PO', (SELECT requisition_header_id FROM
3241: po_requisition_lines_all
3242: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3243: FROM po_requisition_lines_all prl
3244: WHERE prl.line_location_id = pll.line_location_id)
3245: AND p_calling_program = 'POXBWVRP_PO'),

Line 3243: FROM po_requisition_lines_all prl

3239:
3240: 'POXBWVRP_PO', (SELECT requisition_header_id FROM
3241: po_requisition_lines_all
3242: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3243: FROM po_requisition_lines_all prl
3244: WHERE prl.line_location_id = pll.line_location_id)
3245: AND p_calling_program = 'POXBWVRP_PO'),
3246: 'AUTOCREATED_DOC_WF', (SELECT requisition_header_id FROM
3247: po_requisition_lines_all

Line 3247: po_requisition_lines_all

3243: FROM po_requisition_lines_all prl
3244: WHERE prl.line_location_id = pll.line_location_id)
3245: AND p_calling_program = 'POXBWVRP_PO'),
3246: 'AUTOCREATED_DOC_WF', (SELECT requisition_header_id FROM
3247: po_requisition_lines_all
3248: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3249: FROM po_requisition_lines_all prl
3250: WHERE prl.line_location_id = pll.line_location_id)
3251: AND p_calling_program = 'AUTOCREATED_DOC_WF'),

Line 3249: FROM po_requisition_lines_all prl

3245: AND p_calling_program = 'POXBWVRP_PO'),
3246: 'AUTOCREATED_DOC_WF', (SELECT requisition_header_id FROM
3247: po_requisition_lines_all
3248: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3249: FROM po_requisition_lines_all prl
3250: WHERE prl.line_location_id = pll.line_location_id)
3251: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
3252: 'PORELGEB', (SELECT requisition_header_id FROM
3253: po_requisition_lines_all

Line 3253: po_requisition_lines_all

3249: FROM po_requisition_lines_all prl
3250: WHERE prl.line_location_id = pll.line_location_id)
3251: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
3252: 'PORELGEB', (SELECT requisition_header_id FROM
3253: po_requisition_lines_all
3254: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3255: FROM po_requisition_lines_all prl
3256: WHERE prl.line_location_id = pll.line_location_id)
3257: AND p_calling_program = 'PORELGEB'),

Line 3255: FROM po_requisition_lines_all prl

3251: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
3252: 'PORELGEB', (SELECT requisition_header_id FROM
3253: po_requisition_lines_all
3254: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3255: FROM po_requisition_lines_all prl
3256: WHERE prl.line_location_id = pll.line_location_id)
3257: AND p_calling_program = 'PORELGEB'),
3258: null)
3259: ,DECODE(p_calling_program, --source_line_id

Line 3262: FROM po_requisition_lines_all prl

3258: null)
3259: ,DECODE(p_calling_program, --source_line_id
3260: 'COPY_DOCUMENT', pll.original_shipment_id,
3261: 'POXBWVRP_PO',(SELECT Min(requisition_line_id) --source_line_id
3262: FROM po_requisition_lines_all prl
3263: WHERE prl.line_location_id = pll.line_location_id
3264: AND p_calling_program = 'POXBWVRP_PO'),
3265: 'AUTOCREATED_DOC_WF',(SELECT Min(requisition_line_id) --source_line_id
3266: FROM po_requisition_lines_all prl

Line 3266: FROM po_requisition_lines_all prl

3262: FROM po_requisition_lines_all prl
3263: WHERE prl.line_location_id = pll.line_location_id
3264: AND p_calling_program = 'POXBWVRP_PO'),
3265: 'AUTOCREATED_DOC_WF',(SELECT Min(requisition_line_id) --source_line_id
3266: FROM po_requisition_lines_all prl
3267: WHERE prl.line_location_id = pll.line_location_id
3268: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
3269: 'PORELGEB',(SELECT Min(requisition_line_id) --source_line_id
3270: FROM po_requisition_lines_all prl

Line 3270: FROM po_requisition_lines_all prl

3266: FROM po_requisition_lines_all prl
3267: WHERE prl.line_location_id = pll.line_location_id
3268: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
3269: 'PORELGEB',(SELECT Min(requisition_line_id) --source_line_id
3270: FROM po_requisition_lines_all prl
3271: WHERE prl.line_location_id = pll.line_location_id
3272: AND p_calling_program = 'PORELGEB'),
3273: null)
3274: ,DECODE(p_calling_program, --source_trx_level_type

Line 3547: po_requisition_lines_all

3543: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3544: null)
3545: ,DECODE(p_calling_program, -- source_trx_id
3546: 'POXBWVRP_PO', (SELECT requisition_header_id FROM
3547: po_requisition_lines_all
3548: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3549: FROM po_requisition_lines_all prl
3550: WHERE prl.line_location_id = pll.line_location_id)
3551: AND p_calling_program = 'POXBWVRP_PO'),

Line 3549: FROM po_requisition_lines_all prl

3545: ,DECODE(p_calling_program, -- source_trx_id
3546: 'POXBWVRP_PO', (SELECT requisition_header_id FROM
3547: po_requisition_lines_all
3548: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3549: FROM po_requisition_lines_all prl
3550: WHERE prl.line_location_id = pll.line_location_id)
3551: AND p_calling_program = 'POXBWVRP_PO'),
3552: 'AUTOCREATED_DOC_WF', (SELECT requisition_header_id FROM
3553: po_requisition_lines_all

Line 3553: po_requisition_lines_all

3549: FROM po_requisition_lines_all prl
3550: WHERE prl.line_location_id = pll.line_location_id)
3551: AND p_calling_program = 'POXBWVRP_PO'),
3552: 'AUTOCREATED_DOC_WF', (SELECT requisition_header_id FROM
3553: po_requisition_lines_all
3554: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3555: FROM po_requisition_lines_all prl
3556: WHERE prl.line_location_id = pll.line_location_id)
3557: AND p_calling_program = 'AUTOCREATED_DOC_WF'),

Line 3555: FROM po_requisition_lines_all prl

3551: AND p_calling_program = 'POXBWVRP_PO'),
3552: 'AUTOCREATED_DOC_WF', (SELECT requisition_header_id FROM
3553: po_requisition_lines_all
3554: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3555: FROM po_requisition_lines_all prl
3556: WHERE prl.line_location_id = pll.line_location_id)
3557: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
3558: 'PORELGEB', (SELECT requisition_header_id FROM
3559: po_requisition_lines_all

Line 3559: po_requisition_lines_all

3555: FROM po_requisition_lines_all prl
3556: WHERE prl.line_location_id = pll.line_location_id)
3557: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
3558: 'PORELGEB', (SELECT requisition_header_id FROM
3559: po_requisition_lines_all
3560: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3561: FROM po_requisition_lines_all prl
3562: WHERE prl.line_location_id = pll.line_location_id)
3563: AND p_calling_program = 'PORELGEB'),

Line 3561: FROM po_requisition_lines_all prl

3557: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
3558: 'PORELGEB', (SELECT requisition_header_id FROM
3559: po_requisition_lines_all
3560: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3561: FROM po_requisition_lines_all prl
3562: WHERE prl.line_location_id = pll.line_location_id)
3563: AND p_calling_program = 'PORELGEB'),
3564: null)
3565: ,DECODE(p_calling_program, --source_line_id

Line 3567: FROM po_requisition_lines_all prl

3563: AND p_calling_program = 'PORELGEB'),
3564: null)
3565: ,DECODE(p_calling_program, --source_line_id
3566: 'POXBWVRP_PO',(SELECT Min(requisition_line_id) --source_line_id
3567: FROM po_requisition_lines_all prl
3568: WHERE prl.line_location_id = pll.line_location_id
3569: AND p_calling_program = 'POXBWVRP_PO'),
3570: 'AUTOCREATED_DOC_WF',(SELECT Min(requisition_line_id) --source_line_id
3571: FROM po_requisition_lines_all prl

Line 3571: FROM po_requisition_lines_all prl

3567: FROM po_requisition_lines_all prl
3568: WHERE prl.line_location_id = pll.line_location_id
3569: AND p_calling_program = 'POXBWVRP_PO'),
3570: 'AUTOCREATED_DOC_WF',(SELECT Min(requisition_line_id) --source_line_id
3571: FROM po_requisition_lines_all prl
3572: WHERE prl.line_location_id = pll.line_location_id
3573: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
3574: 'PORELGEB',(SELECT Min(requisition_line_id) --source_line_id
3575: FROM po_requisition_lines_all prl

Line 3575: FROM po_requisition_lines_all prl

3571: FROM po_requisition_lines_all prl
3572: WHERE prl.line_location_id = pll.line_location_id
3573: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
3574: 'PORELGEB',(SELECT Min(requisition_line_id) --source_line_id
3575: FROM po_requisition_lines_all prl
3576: WHERE prl.line_location_id = pll.line_location_id
3577: AND p_calling_program = 'PORELGEB'),
3578: null)
3579: ,DECODE(p_calling_program, --source_trx_level_type

Line 3901: po_requisition_lines_all

3897: WHERE source_shipment.line_location_id = pll.original_shipment_id
3898: AND p_calling_program = 'COPY_DOCUMENT'),
3899:
3900: 'POXBWVRP_PO', (SELECT requisition_header_id FROM
3901: po_requisition_lines_all
3902: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3903: FROM po_requisition_lines_all prl
3904: WHERE prl.line_location_id = pll.line_location_id)
3905: AND p_calling_program = 'POXBWVRP_PO'),

Line 3903: FROM po_requisition_lines_all prl

3899:
3900: 'POXBWVRP_PO', (SELECT requisition_header_id FROM
3901: po_requisition_lines_all
3902: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3903: FROM po_requisition_lines_all prl
3904: WHERE prl.line_location_id = pll.line_location_id)
3905: AND p_calling_program = 'POXBWVRP_PO'),
3906: 'AUTOCREATED_DOC_WF', (SELECT requisition_header_id FROM
3907: po_requisition_lines_all

Line 3907: po_requisition_lines_all

3903: FROM po_requisition_lines_all prl
3904: WHERE prl.line_location_id = pll.line_location_id)
3905: AND p_calling_program = 'POXBWVRP_PO'),
3906: 'AUTOCREATED_DOC_WF', (SELECT requisition_header_id FROM
3907: po_requisition_lines_all
3908: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3909: FROM po_requisition_lines_all prl
3910: WHERE prl.line_location_id = pll.line_location_id)
3911: AND p_calling_program = 'AUTOCREATED_DOC_WF'),

Line 3909: FROM po_requisition_lines_all prl

3905: AND p_calling_program = 'POXBWVRP_PO'),
3906: 'AUTOCREATED_DOC_WF', (SELECT requisition_header_id FROM
3907: po_requisition_lines_all
3908: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3909: FROM po_requisition_lines_all prl
3910: WHERE prl.line_location_id = pll.line_location_id)
3911: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
3912: 'PORELGEB', (SELECT requisition_header_id FROM
3913: po_requisition_lines_all

Line 3913: po_requisition_lines_all

3909: FROM po_requisition_lines_all prl
3910: WHERE prl.line_location_id = pll.line_location_id)
3911: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
3912: 'PORELGEB', (SELECT requisition_header_id FROM
3913: po_requisition_lines_all
3914: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3915: FROM po_requisition_lines_all prl
3916: WHERE prl.line_location_id = pll.line_location_id)
3917: AND p_calling_program = 'PORELGEB'),

Line 3915: FROM po_requisition_lines_all prl

3911: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
3912: 'PORELGEB', (SELECT requisition_header_id FROM
3913: po_requisition_lines_all
3914: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
3915: FROM po_requisition_lines_all prl
3916: WHERE prl.line_location_id = pll.line_location_id)
3917: AND p_calling_program = 'PORELGEB'),
3918: null)
3919: ,DECODE(p_calling_program, --source_line_id

Line 3922: FROM po_requisition_lines_all prl

3918: null)
3919: ,DECODE(p_calling_program, --source_line_id
3920: 'COPY_DOCUMENT', pll.original_shipment_id,
3921: 'POXBWVRP_PO',(SELECT Min(requisition_line_id) --source_line_id
3922: FROM po_requisition_lines_all prl
3923: WHERE prl.line_location_id = pll.line_location_id
3924: AND p_calling_program = 'POXBWVRP_PO'),
3925: 'AUTOCREATED_DOC_WF',(SELECT Min(requisition_line_id) --source_line_id
3926: FROM po_requisition_lines_all prl

Line 3926: FROM po_requisition_lines_all prl

3922: FROM po_requisition_lines_all prl
3923: WHERE prl.line_location_id = pll.line_location_id
3924: AND p_calling_program = 'POXBWVRP_PO'),
3925: 'AUTOCREATED_DOC_WF',(SELECT Min(requisition_line_id) --source_line_id
3926: FROM po_requisition_lines_all prl
3927: WHERE prl.line_location_id = pll.line_location_id
3928: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
3929: 'PORELGEB',(SELECT Min(requisition_line_id) --source_line_id
3930: FROM po_requisition_lines_all prl

Line 3930: FROM po_requisition_lines_all prl

3926: FROM po_requisition_lines_all prl
3927: WHERE prl.line_location_id = pll.line_location_id
3928: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
3929: 'PORELGEB',(SELECT Min(requisition_line_id) --source_line_id
3930: FROM po_requisition_lines_all prl
3931: WHERE prl.line_location_id = pll.line_location_id
3932: AND p_calling_program = 'PORELGEB'),
3933: null)
3934: ,DECODE(p_calling_program, --source_trx_level_type

Line 4203: po_requisition_lines_all

4199: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
4200: null)
4201: ,DECODE(p_calling_program, -- source_trx_id
4202: 'POXBWVRP_PO', (SELECT requisition_header_id FROM
4203: po_requisition_lines_all
4204: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
4205: FROM po_requisition_lines_all prl
4206: WHERE prl.line_location_id = pll.line_location_id)
4207: AND p_calling_program = 'POXBWVRP_PO'),

Line 4205: FROM po_requisition_lines_all prl

4201: ,DECODE(p_calling_program, -- source_trx_id
4202: 'POXBWVRP_PO', (SELECT requisition_header_id FROM
4203: po_requisition_lines_all
4204: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
4205: FROM po_requisition_lines_all prl
4206: WHERE prl.line_location_id = pll.line_location_id)
4207: AND p_calling_program = 'POXBWVRP_PO'),
4208: 'AUTOCREATED_DOC_WF', (SELECT requisition_header_id FROM
4209: po_requisition_lines_all

Line 4209: po_requisition_lines_all

4205: FROM po_requisition_lines_all prl
4206: WHERE prl.line_location_id = pll.line_location_id)
4207: AND p_calling_program = 'POXBWVRP_PO'),
4208: 'AUTOCREATED_DOC_WF', (SELECT requisition_header_id FROM
4209: po_requisition_lines_all
4210: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
4211: FROM po_requisition_lines_all prl
4212: WHERE prl.line_location_id = pll.line_location_id)
4213: AND p_calling_program = 'AUTOCREATED_DOC_WF'),

Line 4211: FROM po_requisition_lines_all prl

4207: AND p_calling_program = 'POXBWVRP_PO'),
4208: 'AUTOCREATED_DOC_WF', (SELECT requisition_header_id FROM
4209: po_requisition_lines_all
4210: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
4211: FROM po_requisition_lines_all prl
4212: WHERE prl.line_location_id = pll.line_location_id)
4213: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
4214: 'PORELGEB', (SELECT requisition_header_id FROM
4215: po_requisition_lines_all

Line 4215: po_requisition_lines_all

4211: FROM po_requisition_lines_all prl
4212: WHERE prl.line_location_id = pll.line_location_id)
4213: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
4214: 'PORELGEB', (SELECT requisition_header_id FROM
4215: po_requisition_lines_all
4216: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
4217: FROM po_requisition_lines_all prl
4218: WHERE prl.line_location_id = pll.line_location_id)
4219: AND p_calling_program = 'PORELGEB'),

Line 4217: FROM po_requisition_lines_all prl

4213: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
4214: 'PORELGEB', (SELECT requisition_header_id FROM
4215: po_requisition_lines_all
4216: WHERE requisition_line_id IN (SELECT Min(requisition_line_id) --source_trx_id
4217: FROM po_requisition_lines_all prl
4218: WHERE prl.line_location_id = pll.line_location_id)
4219: AND p_calling_program = 'PORELGEB'),
4220: null)
4221: ,DECODE(p_calling_program, --source_line_id

Line 4223: FROM po_requisition_lines_all prl

4219: AND p_calling_program = 'PORELGEB'),
4220: null)
4221: ,DECODE(p_calling_program, --source_line_id
4222: 'POXBWVRP_PO',(SELECT Min(requisition_line_id) --source_line_id
4223: FROM po_requisition_lines_all prl
4224: WHERE prl.line_location_id = pll.line_location_id
4225: AND p_calling_program = 'POXBWVRP_PO'),
4226: 'AUTOCREATED_DOC_WF',(SELECT Min(requisition_line_id) --source_line_id
4227: FROM po_requisition_lines_all prl

Line 4227: FROM po_requisition_lines_all prl

4223: FROM po_requisition_lines_all prl
4224: WHERE prl.line_location_id = pll.line_location_id
4225: AND p_calling_program = 'POXBWVRP_PO'),
4226: 'AUTOCREATED_DOC_WF',(SELECT Min(requisition_line_id) --source_line_id
4227: FROM po_requisition_lines_all prl
4228: WHERE prl.line_location_id = pll.line_location_id
4229: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
4230: 'PORELGEB',(SELECT Min(requisition_line_id) --source_line_id
4231: FROM po_requisition_lines_all prl

Line 4231: FROM po_requisition_lines_all prl

4227: FROM po_requisition_lines_all prl
4228: WHERE prl.line_location_id = pll.line_location_id
4229: AND p_calling_program = 'AUTOCREATED_DOC_WF'),
4230: 'PORELGEB',(SELECT Min(requisition_line_id) --source_line_id
4231: FROM po_requisition_lines_all prl
4232: WHERE prl.line_location_id = pll.line_location_id
4233: AND p_calling_program = 'PORELGEB'),
4234: null)
4235: ,DECODE(p_calling_program, --source_trx_level_type

Line 4343: l_functional_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;

4339: -----------------------------------------------------------------------------
4340: PROCEDURE populate_zx_lines_with_req(p_requisition_header_id IN NUMBER,
4341: p_calling_program IN VARCHAR2
4342: ) IS
4343: l_functional_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
4344: l_set_of_books_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;
4345: l_rate_type PO_REQUISITION_LINES_ALL.rate_type%TYPE;
4346: l_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
4347: BEGIN

Line 4345: l_rate_type PO_REQUISITION_LINES_ALL.rate_type%TYPE;

4341: p_calling_program IN VARCHAR2
4342: ) IS
4343: l_functional_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
4344: l_set_of_books_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;
4345: l_rate_type PO_REQUISITION_LINES_ALL.rate_type%TYPE;
4346: l_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
4347: BEGIN
4348:
4349: -- Get the requisition's functional currency info.

Line 4346: l_rate PO_REQUISITION_LINES_ALL.rate%TYPE;

4342: ) IS
4343: l_functional_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
4344: l_set_of_books_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;
4345: l_rate_type PO_REQUISITION_LINES_ALL.rate_type%TYPE;
4346: l_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
4347: BEGIN
4348:
4349: -- Get the requisition's functional currency info.
4350: -- This piece of code is similar to PO_GA_PVT.get_currency_info except that

Line 4550: FROM po_requisition_headers_all prh, po_requisition_lines_all prl,

4546: ,Decode (p_calling_program,
4547: 'REQUISITION_MODIFY', zxldet.user_upd_det_factors_flag,
4548: 'REQIMPORT', NVL2(PRL.TAX_NAME,'Y',NULL))
4549: ,prl.destination_organization_id --Bug#6902111
4550: FROM po_requisition_headers_all prh, po_requisition_lines_all prl,
4551: zx_lines_det_factors zxldet, po_vendors pv, po_vendor_sites_all pvs,
4552: mtl_system_items_b msib, fnd_currencies fc
4553: WHERE prh.requisition_header_id = p_requisition_header_id
4554: AND prh.requisition_header_id = prl.requisition_header_id

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'

Line 5171: po_requisition_lines_all PRL

5167: FROM DUAL
5168: WHERE EXISTS
5169: (SELECT 'Y'
5170: FROM po_requisition_headers_all PRH,
5171: po_requisition_lines_all PRL
5172: WHERE PRH.requisition_header_id = p_req_header_id
5173: AND PRH.requisition_header_id = PRL.requisition_header_id
5174: AND NVL(PRL.cancel_flag, 'N') = 'N'
5175: AND NVL(PRL.closed_code, 'OPEN') <> 'FINALLY CLOSED'

Line 6616: FROM po_requisition_lines_all prl

6612:
6613: l_line_id_tbl := null; l_line_tauc_tbl := null;
6614: SELECT prl.requisition_line_id, prl.tax_attribute_update_code
6615: BULK COLLECT INTO l_line_id_tbl, l_line_tauc_tbl
6616: FROM po_requisition_lines_all prl
6617: WHERE prl.requisition_header_id = p_requisition_header_id;
6618:
6619: FOR i IN 1..l_line_id_tbl.COUNT LOOP
6620: PO_LOG.stmt(d_module_base,d_progress,' requisition_line_id = '||l_line_id_tbl(i)||':'||l_line_tauc_tbl(i));