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_LINE_LOCATIONS_ALL

Line 99: -- PO_LINE_LOCATIONS_ALL.tax_attribute_update_code

95: --Pre-reqs:
96: -- Should be called when transaction data has been posted to the database
97: -- but not yet committed
98: --Modifies:
99: -- PO_LINE_LOCATIONS_ALL.tax_attribute_update_code
100: -- PO_LINE_LOCATIONS_ALL.original_shipment_id
101: -- PO_LINE_LOCATIONS_ALL.taxable_flag
102: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax
103: -- PO_DISTRIBUTIONS_ALL.recoverable_tax

Line 100: -- PO_LINE_LOCATIONS_ALL.original_shipment_id

96: -- Should be called when transaction data has been posted to the database
97: -- but not yet committed
98: --Modifies:
99: -- PO_LINE_LOCATIONS_ALL.tax_attribute_update_code
100: -- PO_LINE_LOCATIONS_ALL.original_shipment_id
101: -- PO_LINE_LOCATIONS_ALL.taxable_flag
102: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax
103: -- PO_DISTRIBUTIONS_ALL.recoverable_tax
104: --Locks:

Line 101: -- PO_LINE_LOCATIONS_ALL.taxable_flag

97: -- but not yet committed
98: --Modifies:
99: -- PO_LINE_LOCATIONS_ALL.tax_attribute_update_code
100: -- PO_LINE_LOCATIONS_ALL.original_shipment_id
101: -- PO_LINE_LOCATIONS_ALL.taxable_flag
102: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax
103: -- PO_DISTRIBUTIONS_ALL.recoverable_tax
104: --Locks:
105: -- Transaction tables if update is allowed

Line 212: UPDATE po_line_locations_all pll

208: zx_transaction_lines_gt and no call is being made to ZX calculate_tax API. Updating shipments
209: tax_attribute_update_code accordingly to overcome above issue */
210:
211: FORALL i IN 1..p_po_header_id_tbl.COUNT
212: UPDATE po_line_locations_all pll
213: SET pll.tax_attribute_update_code =
214: NVL ((SELECT NVL (
215: (SELECT pod.tax_attribute_update_code
216: FROM po_distributions_all pod

Line 235: UPDATE po_line_locations_all pll

231: OR pll.tax_attribute_update_code = 'DIST_DELETE');
232:
233: d_progress := 50;
234: FORALL i IN 1..p_po_release_id_tbl.COUNT
235: UPDATE po_line_locations_all pll
236: SET pll.tax_attribute_update_code =
237: NVL(
238: (SELECT NVL (
239: (SELECT pod.tax_attribute_update_code

Line 482: FROM po_line_locations_all pll, po_lines_all pl

478: SET zxlgt.product_type =
479: (SELECT DECODE(pl.purchase_basis,
480: 'GOODS', 'GOODS',
481: 'SERVICES')
482: FROM po_line_locations_all pll, po_lines_all pl
483: WHERE pll.line_location_id = zxlgt.trx_line_id
484: AND pll.po_line_id = pl.po_line_id)
485: WHERE zxlgt.product_type IS NULL
486: AND zxlgt.line_level_action = 'CREATE';

Line 905: UPDATE po_line_locations_all

901:
902: -- bug5219124 START
903: -- Separate the original update statement into two
904:
905: UPDATE po_line_locations_all
906: SET tax_attribute_update_code = null,
907: original_shipment_id = null
908: WHERE line_location_id IN (SELECT trx_line_id FROM zx_transaction_lines_gt);
909:

Line 910: UPDATE po_line_locations_all

906: SET tax_attribute_update_code = null,
907: original_shipment_id = null
908: WHERE line_location_id IN (SELECT trx_line_id FROM zx_transaction_lines_gt);
909:
910: UPDATE po_line_locations_all
911: SET tax_attribute_update_code = null,
912: original_shipment_id = null
913: WHERE tax_attribute_update_code = 'DIST_DELETE'
914: AND line_location_id IN (SELECT trx_line_id FROM zx_itm_distributions_gt);

Line 932: UPDATE po_line_locations_all pll

928: -- Add a join to zl.trx_id so that the index on zx_lines can be used
929: -- more efficiently
930:
931: -- Set the taxable flag column of shipments which have tax lines
932: UPDATE po_line_locations_all pll
933: SET pll.taxable_flag =
934: DECODE((SELECT COUNT(1) FROM zx_lines zl
935: WHERE zl.trx_line_id = pll.line_location_id
936: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID

Line 969: FROM po_session_gt psgt, po_line_locations_all pll, po_distributions_all pd

965: ,pd.po_distribution_id --distribution_id
966: ,pd.distribution_num --distribution_num
967: ,psgt.char2 --message_text
968: BULK COLLECT INTO G_TAX_ERRORS_TBL
969: FROM po_session_gt psgt, po_line_locations_all pll, po_distributions_all pd
970: WHERE psgt.num1 = pll.line_location_id
971: AND psgt.num2 = pd.po_distribution_id(+)
972: AND psgt.key = l_po_session_gt_key;
973:

Line 1013: FROM po_session_gt psgt, po_line_locations_all pll, po_distributions_all pd

1009: ,pd.po_distribution_id --distribution_id
1010: ,pd.distribution_num --distribution_num
1011: ,psgt.char2 --message_text
1012: BULK COLLECT INTO G_TAX_ERRORS_TBL
1013: FROM po_session_gt psgt, po_line_locations_all pll, po_distributions_all pd
1014: WHERE psgt.index_num1 = pll.po_header_id
1015: AND pll.line_location_id = pd.line_location_id
1016: AND psgt.key = l_po_session_gt_key;
1017:

Line 1086: -- PO_LINE_LOCATIONS_ALL.tax_attribute_update_code

1082: --Pre-reqs:
1083: -- Should be called when transaction data has been posted to the database
1084: -- but not yet committed
1085: --Modifies:
1086: -- PO_LINE_LOCATIONS_ALL.tax_attribute_update_code
1087: -- PO_LINE_LOCATIONS_ALL.original_shipment_id
1088: -- PO_LINE_LOCATIONS_ALL.taxable_flag
1089: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax
1090: -- PO_DISTRIBUTIONS_ALL.recoverable_tax

Line 1087: -- PO_LINE_LOCATIONS_ALL.original_shipment_id

1083: -- Should be called when transaction data has been posted to the database
1084: -- but not yet committed
1085: --Modifies:
1086: -- PO_LINE_LOCATIONS_ALL.tax_attribute_update_code
1087: -- PO_LINE_LOCATIONS_ALL.original_shipment_id
1088: -- PO_LINE_LOCATIONS_ALL.taxable_flag
1089: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax
1090: -- PO_DISTRIBUTIONS_ALL.recoverable_tax
1091: --Locks:

Line 1088: -- PO_LINE_LOCATIONS_ALL.taxable_flag

1084: -- but not yet committed
1085: --Modifies:
1086: -- PO_LINE_LOCATIONS_ALL.tax_attribute_update_code
1087: -- PO_LINE_LOCATIONS_ALL.original_shipment_id
1088: -- PO_LINE_LOCATIONS_ALL.taxable_flag
1089: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax
1090: -- PO_DISTRIBUTIONS_ALL.recoverable_tax
1091: --Locks:
1092: -- Transaction tables if update is allowed

Line 1944: po_line_locations_all pll, po_distributions_all pd

1940: ,pd.distribution_num --distribution_num,
1941: ,zxegt.message_text --message_text
1942: BULK COLLECT INTO G_TAX_ERRORS_TBL
1943: FROM zx_errors_gt zxegt, po_headers_all ph,
1944: po_line_locations_all pll, po_distributions_all pd
1945: WHERE zxegt.trx_id = ph.po_header_id
1946: AND zxegt.trx_line_id = pll.line_location_id(+)
1947: AND zxegt.trx_line_dist_id = pd.po_distribution_id(+);
1948:

Line 1994: UPDATE po_line_locations_all pll

1990: WHERE pd.po_distribution_id IN
1991: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
1992:
1993: /* Bug 6157632 Start */
1994: UPDATE po_line_locations_all pll
1995: SET pll.taxable_flag =
1996: DECODE((SELECT COUNT(1) FROM zx_lines zl
1997: WHERE zl.trx_line_id = pll.line_location_id
1998: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID

Line 2178: po_line_locations_all pll, po_distributions_all pd

2174: ,pd.distribution_num --distribution_num,
2175: ,zxegt.message_text --message_text
2176: BULK COLLECT INTO G_TAX_ERRORS_TBL
2177: FROM zx_errors_gt zxegt, po_releases_all pr, po_headers_all ph,
2178: po_line_locations_all pll, po_distributions_all pd
2179: WHERE zxegt.trx_id = pr.po_release_id
2180: AND pr.po_header_id = ph.po_header_id
2181: AND zxegt.trx_line_id = pll.line_location_id(+)
2182: AND zxegt.trx_line_dist_id = pd.po_distribution_id(+);

Line 2224: UPDATE po_line_locations_all pll

2220: WHERE pd.po_distribution_id IN
2221: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
2222:
2223: /* Bug 6157632 Start */
2224: UPDATE po_line_locations_all pll
2225: SET pll.taxable_flag =
2226: DECODE((SELECT COUNT(1) FROM zx_lines zl
2227: WHERE zl.trx_line_id = pll.line_location_id
2228: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID

Line 2568: FROM po_line_locations_all pll

2564: zxldet.document_sub_type)
2565: ,DECODE(ph.document_creation_method, --provnl_tax_determination_date
2566: 'CREATE_CONSUMPTION',
2567: (SELECT pll.need_by_date
2568: FROM po_line_locations_all pll
2569: WHERE pll.po_header_id=ph.po_header_id
2570: AND pll.need_by_date IS NOT NULL
2571: AND rownum=1),
2572: null)

Line 2676: FROM po_line_locations_all pll

2672: ,null --document_sub_type
2673: ,DECODE(ph.document_creation_method, --provnl_tax_determination_date
2674: 'CREATE_CONSUMPTION',
2675: (SELECT pll.need_by_date
2676: FROM po_line_locations_all pll
2677: WHERE pll.po_header_id=ph.po_header_id
2678: AND pll.need_by_date IS NOT NULL
2679: AND rownum=1),
2680: null)

Line 2781: FROM po_line_locations_all pll

2777: ,zxldet.document_sub_type --document_sub_type
2778: ,DECODE(pr.document_creation_method, --provnl_tax_determination_date
2779: 'CREATE_CONSUMPTION',
2780: (SELECT pll.need_by_date
2781: FROM po_line_locations_all pll
2782: WHERE pll.po_release_id=pr.po_release_id
2783: AND pll.need_by_date IS NOT NULL
2784: AND rownum=1),
2785: null)

Line 2904: FROM po_line_locations_all pll

2900: ,null --document_sub_type
2901: ,DECODE(pr.document_creation_method, --provnl_tax_determination_date
2902: 'CREATE_CONSUMPTION',
2903: (SELECT pll.need_by_date
2904: FROM po_line_locations_all pll
2905: WHERE pll.po_release_id=pr.po_release_id
2906: AND pll.need_by_date IS NOT NULL
2907: AND rownum=1),
2908: null)

Line 3236: FROM po_line_locations_all source_shipment

3232: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3233: null)
3234: ,DECODE(p_calling_program, -- source_trx_id
3235: 'COPY_DOCUMENT', (SELECT source_shipment.po_header_id --source_trx_id
3236: FROM po_line_locations_all source_shipment
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

Line 3293: FROM po_headers_all ph, po_lines_all pl, po_line_locations_all pll,

3289: ,(SELECT 'Y' FROM DUAL --user_upd_det_factors_flag
3290: WHERE p_calling_program = 'PDOI'
3291: AND pll.tax_name IS NOT NULL)
3292: ,pll.ship_to_organization_id --Bug#6902111
3293: FROM po_headers_all ph, po_lines_all pl, po_line_locations_all pll,
3294: zx_lines_det_factors zxldet, po_vendors pv,
3295: po_vendor_sites_all pvs, mtl_system_items_b msib
3296: WHERE ph.po_header_id = pll.po_header_id
3297: AND pl.po_line_id = pll.po_line_id

Line 3611: ,po_line_locations_all pll

3607: -- Join with items table for item information
3608: LEFT OUTER JOIN mtl_system_items_b msib
3609: ON (pl.item_id = msib.inventory_item_id
3610: AND pl.org_id = msib.organization_id)
3611: ,po_line_locations_all pll
3612: -- Conditions for getting Additional Tax Attributes
3613: -- Do not put a condition on zxldet.trx_id here because that would
3614: -- entail bringing the source_header_id for the shipment being
3615: -- currently processed. Join with trx_line_id itself is unique

Line 3662: These 2 procedures uses a join for zx_lines_det_factors and po_line_locations_all

3658: populate_zx_lines_with_rel_cal which populates the data in zx_transaction_lines_gt
3659: only when the shipments is received or billed or shipped. This has been done for these
3660: shipments to skip the call to get_default_tax_attribs as per the EB Tax suggestion in bug
3661: 11665348 to fulfill requirement by PO PM team to retain the tax on received/billed shipments.
3662: These 2 procedures uses a join for zx_lines_det_factors and po_line_locations_all
3663: ON line_location_id instead of original_shipment_id as we need to pass value of
3664: input_tax_classification_code for receioved/billed PO shipments as per the suggestion
3665: of EB Tax team in bug 11711366
3666: */

Line 3896: FROM po_line_locations_all source_shipment

3892: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3893: null)
3894: ,DECODE(p_calling_program, -- source_trx_id
3895: 'COPY_DOCUMENT', (SELECT source_shipment.po_header_id --source_trx_id
3896: FROM po_line_locations_all source_shipment
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

Line 3953: FROM po_headers_all ph, po_lines_all pl, po_line_locations_all pll,

3949: ,(SELECT 'Y' FROM DUAL --user_upd_det_factors_flag
3950: WHERE p_calling_program = 'PDOI'
3951: AND pll.tax_name IS NOT NULL)
3952: ,pll.ship_to_organization_id --Bug#6902111
3953: FROM po_headers_all ph, po_lines_all pl, po_line_locations_all pll,
3954: zx_lines_det_factors zxldet, po_vendors pv,
3955: po_vendor_sites_all pvs, mtl_system_items_b msib
3956: WHERE ph.po_header_id = pll.po_header_id
3957: AND pl.po_line_id = pll.po_line_id

Line 4267: ,po_line_locations_all pll

4263: -- Join with items table for item information
4264: LEFT OUTER JOIN mtl_system_items_b msib
4265: ON (pl.item_id = msib.inventory_item_id
4266: AND pl.org_id = msib.organization_id)
4267: ,po_line_locations_all pll
4268: LEFT OUTER JOIN zx_lines_det_factors zxldet ON
4269: -- Bug#12622509: The performance of the SQL is very bad, as FULL TABLE
4270: -- SCAN is performed on the table zx_lines_det_factors.
4271: (PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id

Line 4666: FROM po_distributions_all pd1, po_line_locations_all pll, po_lines_all pl

4662: ,pll.quantity --trx_line_quantity
4663: ,pd1.code_combination_id --account_ccid
4664: ,pd1.rate --currency_exchange_rate
4665: , decode(pd1.tax_recovery_override_flag, 'Y', pd1.recovery_rate, null) --overriding_recovery_rate
4666: FROM po_distributions_all pd1, po_line_locations_all pll, po_lines_all pl
4667: WHERE pd1.po_header_id = p_po_header_id_tbl(i)
4668: AND pd1.line_location_id=pll.line_location_id
4669: AND pll.po_line_id=pl.po_line_id
4670: AND (EXISTS(SELECT 'SIBLING DIST WITH TAUC'

Line 4759: FROM po_distributions_all pd, po_line_locations_all pll, po_lines_all pl

4755: ,pll.quantity --trx_line_quantity
4756: ,pd.code_combination_id --account_ccid
4757: ,pd.rate --currency_exchange_rate
4758: , decode(pd.tax_recovery_override_flag, 'Y', pd.recovery_rate, null) --overriding_recovery_rate
4759: FROM po_distributions_all pd, po_line_locations_all pll, po_lines_all pl
4760: WHERE pd.po_header_id = p_po_header_id
4761: AND pd.line_location_id=pll.line_location_id
4762: AND pll.po_line_id = pl.po_line_id
4763: -- Conditions that determine that po line is 'Active'

Line 4863: FROM po_distributions_all pd1, po_line_locations_all pll, po_lines_all pl

4859: ,pll.quantity --trx_line_quantity
4860: ,pd1.code_combination_id --account_ccid
4861: ,pd1.rate --currency_exchange_rate
4862: , decode(pd1.tax_recovery_override_flag, 'Y', pd1.recovery_rate, null) --overriding_recovery_rate
4863: FROM po_distributions_all pd1, po_line_locations_all pll, po_lines_all pl
4864: WHERE pd1.po_release_id = p_po_release_id_tbl(i)
4865: AND pd1.line_location_id=pll.line_location_id
4866: AND pll.po_line_id=pl.po_line_id
4867: AND (EXISTS(SELECT 'SIBLING DIST WITH TAUC'

Line 4956: FROM po_distributions_all pd, po_line_locations_all pll, po_lines_all pl

4952: ,pll.quantity --trx_line_quantity
4953: ,pd.code_combination_id --account_ccid
4954: ,pd.rate --currency_exchange_rate
4955: , decode(pd.tax_recovery_override_flag, 'Y', pd.recovery_rate, null) --overriding_recovery_rate
4956: FROM po_distributions_all pd, po_line_locations_all pll, po_lines_all pl
4957: WHERE pd.po_release_id = p_po_release_id
4958: AND pd.line_location_id = pll.line_location_id
4959: AND pll.po_line_id = pl.po_line_id
4960: -- Conditions that determine that po line is 'Active'

Line 5124: po_line_locations_all PLL,

5120: WHERE EXISTS
5121: (SELECT 'Y'
5122: FROM po_headers_all POH,
5123: po_lines_all POL,
5124: po_line_locations_all PLL,
5125: po_distributions_all POD
5126: WHERE POH.po_header_id = p_po_header_id
5127: AND POH.po_header_id = POL.po_header_id
5128: AND POL.po_line_id = PLL.po_line_id

Line 5150: po_line_locations_all PLL,

5146: FROM DUAL
5147: WHERE EXISTS
5148: (SELECT 'Y'
5149: FROM po_releases_all POR,
5150: po_line_locations_all PLL,
5151: po_distributions_all POD
5152: WHERE POR.po_release_id = p_po_release_id
5153: AND POR.po_release_id = PLL.po_release_id
5154: AND PLL.line_location_id = POD.line_location_id

Line 5437: UPDATE po_line_locations_all

5433: -- for which distributions are deleted
5434: --
5435:
5436: FORALL i IN 1..p_del_dist_shipment_table.COUNT
5437: UPDATE po_line_locations_all
5438: SET tax_attribute_update_code = NVL(tax_attribute_update_code,'DIST_DELETE')
5439: WHERE line_location_id = p_del_dist_shipment_table(i);
5440:
5441: d_progress := 10;

Line 5908: l_qty PO_LINE_LOCATIONS_ALL.QUANTITY%type;

5904: l_vendor_site_id PO_HEADERS_ALL.VENDOR_SITE_ID%type ;
5905: l_bill_to_loc PO_HEADERS_ALL.BILL_TO_LOCATION_ID%type; --
5906: l_uom PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%type;
5907: l_price PO_LINES_ALL.UNIT_PRICE%type;
5908: l_qty PO_LINE_LOCATIONS_ALL.QUANTITY%type;
5909: l_price_override PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDE%type; --
5910: l_amt PO_LINE_LOCATIONS_ALL.AMOUNT%type;
5911: l_ship_to_org PO_LINE_LOCATIONS_ALL.SHIP_TO_ORGANIZATION_ID%type;
5912: l_ship_to_loc PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID%type;

Line 5909: l_price_override PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDE%type; --

5905: l_bill_to_loc PO_HEADERS_ALL.BILL_TO_LOCATION_ID%type; --
5906: l_uom PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%type;
5907: l_price PO_LINES_ALL.UNIT_PRICE%type;
5908: l_qty PO_LINE_LOCATIONS_ALL.QUANTITY%type;
5909: l_price_override PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDE%type; --
5910: l_amt PO_LINE_LOCATIONS_ALL.AMOUNT%type;
5911: l_ship_to_org PO_LINE_LOCATIONS_ALL.SHIP_TO_ORGANIZATION_ID%type;
5912: l_ship_to_loc PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID%type;
5913: l_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%type ;

Line 5910: l_amt PO_LINE_LOCATIONS_ALL.AMOUNT%type;

5906: l_uom PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%type;
5907: l_price PO_LINES_ALL.UNIT_PRICE%type;
5908: l_qty PO_LINE_LOCATIONS_ALL.QUANTITY%type;
5909: l_price_override PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDE%type; --
5910: l_amt PO_LINE_LOCATIONS_ALL.AMOUNT%type;
5911: l_ship_to_org PO_LINE_LOCATIONS_ALL.SHIP_TO_ORGANIZATION_ID%type;
5912: l_ship_to_loc PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID%type;
5913: l_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%type ;
5914: l_ccid PO_DISTRIBUTIONS_ALL.CODE_COMBINATION_ID%type;

Line 5911: l_ship_to_org PO_LINE_LOCATIONS_ALL.SHIP_TO_ORGANIZATION_ID%type;

5907: l_price PO_LINES_ALL.UNIT_PRICE%type;
5908: l_qty PO_LINE_LOCATIONS_ALL.QUANTITY%type;
5909: l_price_override PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDE%type; --
5910: l_amt PO_LINE_LOCATIONS_ALL.AMOUNT%type;
5911: l_ship_to_org PO_LINE_LOCATIONS_ALL.SHIP_TO_ORGANIZATION_ID%type;
5912: l_ship_to_loc PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID%type;
5913: l_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%type ;
5914: l_ccid PO_DISTRIBUTIONS_ALL.CODE_COMBINATION_ID%type;
5915: l_tax_rec_rate PO_DISTRIBUTIONS_ALL.RECOVERY_RATE%type;

Line 5912: l_ship_to_loc PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID%type;

5908: l_qty PO_LINE_LOCATIONS_ALL.QUANTITY%type;
5909: l_price_override PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDE%type; --
5910: l_amt PO_LINE_LOCATIONS_ALL.AMOUNT%type;
5911: l_ship_to_org PO_LINE_LOCATIONS_ALL.SHIP_TO_ORGANIZATION_ID%type;
5912: l_ship_to_loc PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID%type;
5913: l_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%type ;
5914: l_ccid PO_DISTRIBUTIONS_ALL.CODE_COMBINATION_ID%type;
5915: l_tax_rec_rate PO_DISTRIBUTIONS_ALL.RECOVERY_RATE%type;
5916: l_project PO_DISTRIBUTIONS_ALL.PROJECT_ID%type;

Line 5913: l_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%type ;

5909: l_price_override PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDE%type; --
5910: l_amt PO_LINE_LOCATIONS_ALL.AMOUNT%type;
5911: l_ship_to_org PO_LINE_LOCATIONS_ALL.SHIP_TO_ORGANIZATION_ID%type;
5912: l_ship_to_loc PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID%type;
5913: l_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%type ;
5914: l_ccid PO_DISTRIBUTIONS_ALL.CODE_COMBINATION_ID%type;
5915: l_tax_rec_rate PO_DISTRIBUTIONS_ALL.RECOVERY_RATE%type;
5916: l_project PO_DISTRIBUTIONS_ALL.PROJECT_ID%type;
5917: l_task PO_DISTRIBUTIONS_ALL.TASK_ID%type;

Line 6040: FROM po_line_locations_all

6036: l_amt,
6037: l_ship_to_org,
6038: l_ship_to_loc,
6039: l_need_by_date
6040: FROM po_line_locations_all
6041: WHERE line_location_id = p_doc_level_id;
6042:
6043: IF nvl(l_qty ,-99) = nvl(p_qty ,-99) AND
6044: -- Shipment level price is also tax determining

Line 6466: FROM po_line_locations_all pll

6462:
6463: l_ship_id_tbl := null; l_ship_tauc_tbl := null;
6464: SELECT pll.line_location_id, pll.tax_attribute_update_code
6465: BULK COLLECT INTO l_ship_id_tbl, l_ship_tauc_tbl
6466: FROM po_line_locations_all pll
6467: WHERE pll.po_line_id = l_line_id_tbl(j);
6468:
6469: FOR k IN 1..l_ship_id_tbl.COUNT LOOP
6470: PO_LOG.stmt(d_module_base,d_progress,' line_location_id = '||l_ship_id_tbl(k)||':'||l_ship_tauc_tbl(k));

Line 6545: FROM po_line_locations_all pll

6541:
6542: l_ship_id_tbl := null; l_ship_tauc_tbl := null;
6543: SELECT pll.line_location_id, pll.tax_attribute_update_code
6544: BULK COLLECT INTO l_ship_id_tbl, l_ship_tauc_tbl
6545: FROM po_line_locations_all pll
6546: WHERE pll.po_release_id = p_po_release_id_tbl(i);
6547:
6548: FOR j IN 1..l_ship_id_tbl.COUNT LOOP
6549: PO_LOG.stmt(d_module_base,d_progress,' line_location_id = '||l_ship_id_tbl(j)||':'||l_ship_tauc_tbl(j));

Line 6879: FROM po_line_locations_all pll

6875: pll.line_location_id,
6876: 'CANCEL', --line_level_action
6877: 'N', -- dummy value
6878: 0 -- dummy value
6879: FROM po_line_locations_all pll
6880: WHERE pll.po_line_id = p_line_id;
6881:
6882: d_progress := 90;
6883: log_header_tax_attributes(d_module_base,d_progress);

Line 7340: -- PO_LINE_LOCATIONS_ALL.approved_flag

7336: --Name: unapprove_schedules
7337: --Pre-reqs:
7338: -- None
7339: --Modifies:
7340: -- PO_LINE_LOCATIONS_ALL.approved_flag
7341: --Locks:
7342: -- PO_LINE_LOCATIONS_ALL
7343: --Function:
7344: -- Unapprove the given schedules if they are approved

Line 7342: -- PO_LINE_LOCATIONS_ALL

7338: -- None
7339: --Modifies:
7340: -- PO_LINE_LOCATIONS_ALL.approved_flag
7341: --Locks:
7342: -- PO_LINE_LOCATIONS_ALL
7343: --Function:
7344: -- Unapprove the given schedules if they are approved
7345: --Parameters:
7346: --IN:

Line 7384: UPDATE po_line_locations_all pll

7380:
7381: -- Unapprove line locations that are approved
7382: d_progress := 10;
7383: FORALL i IN 1..p_line_location_id_tbl.COUNT
7384: UPDATE po_line_locations_all pll
7385: SET pll.approved_flag = 'R'
7386: WHERE pll.line_location_id = p_line_location_id_tbl(i)
7387: AND pll.approved_flag = 'Y';
7388: