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.AP_MATCHING_PKG dependencies on PO_LINE_LOCATIONS

Line 193: G_Shipment_Type po_line_locations.shipment_type%TYPE;

189: G_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;
190: -- Removed for bug 4277744
191: -- G_Ussgl_Transaction_Code ap_invoices.ussgl_transaction_code%TYPE;
192: G_Allow_Flex_Override_Flag ap_system_parameters.allow_flex_override_flag%TYPE;
193: G_Shipment_Type po_line_locations.shipment_type%TYPE;
194: G_Org_id ap_invoices.org_id%TYPE;
195: G_Encumbrance_Flag financials_system_parameters.purch_encumbrance_flag%TYPE;
196: G_User_Id number;
197: G_Login_Id number;

Line 277: l_po_line_location_id po_line_locations.line_location_id%TYPE;

273: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
274: l_uom_code mtl_units_of_measure.uom_code%TYPE;
275: l_ref_doc_trx_id po_headers_all.po_header_id%TYPE;
276: l_error_code varchar2(2000);
277: l_po_line_location_id po_line_locations.line_location_id%TYPE;
278: l_dummy number;
279: -- bug 7577673: start
280: l_product_org_id ap_invoices.org_id%TYPE;
281: l_allow_tax_code_override varchar2(10);

Line 609: po_line_locations pll

605: l_retained_amount,
606: -1 * l_retained_amount
607: FROM ap_invoice_distributions aid,
608: po_distributions pd,
609: po_line_locations pll
610: WHERE aid.invoice_distribution_id = l_invoice_distribution_id
611: AND pd.po_distribution_id = aid.po_distribution_id
612: AND pll.line_location_id = pd.line_location_id)
613: WHERE ail.invoice_id = x_invoice_id

Line 671: po_line_locations pll

667: --end Bug 7483260
668: l_retained_amount,
669: -1 * l_retained_amount
670: FROM ap_invoice_lines ail1,
671: po_line_locations pll
672: WHERE ail1.invoice_id = x_invoice_id
673: AND ail1.line_number =x_invoice_line_number
674: AND pll.line_location_id = ail1.po_line_location_id)
675: WHERE invoice_id = x_invoice_id

Line 989: FROM po_line_locations pll, po_lines pl

985: IF (x_po_line_location_id IS NOT NULL) THEN
986:
987: SELECT pll.shipment_type, pll.po_line_id, pl.recoupment_rate
988: INTO g_shipment_type, g_po_line_id, g_recoupment_rate
989: FROM po_line_locations pll, po_lines pl
990: WHERE pll.line_location_id = x_po_line_location_id
991: AND pll.po_line_id = pl.po_line_id;
992:
993: END IF;

Line 1830: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS

1826: END IF;
1827: --End Bug#13505998
1828:
1829: -- bug 5061826
1830: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
1831: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V
1832:
1833: INSERT INTO AP_INVOICE_LINES (
1834: INVOICE_ID,

Line 1831: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V

1827: --End Bug#13505998
1828:
1829: -- bug 5061826
1830: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
1831: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V
1832:
1833: INSERT INTO AP_INVOICE_LINES (
1834: INVOICE_ID,
1835: LINE_NUMBER,

Line 2206: PO_LINE_LOCATIONS_ALL PLL,

2202: G_dflt_tax_class_code,
2203: G_PAY_AWT_GROUP_ID --pay_awt_group_id bug8222382
2204: -- bug 5061826 -- new FROM clause that goes to base tables
2205: FROM PO_LINES_ALL PL,
2206: PO_LINE_LOCATIONS_ALL PLL,
2207: po_distributions pd,
2208: mtl_system_items msi
2209: WHERE pll.line_location_id = x_po_line_location_id
2210: and pd.line_location_id = pll.line_location_id

Line 2217: FROM PO_LINE_LOCATIONS_AP_V PLL,

2213: and msi.inventory_item_id(+) = pl.item_id
2214: and msi.organization_id(+) = g_inventory_organization_id
2215: and rownum = 1;
2216: /* -- bug 5061826 -- commented out older FROM clause
2217: FROM PO_LINE_LOCATIONS_AP_V PLL,
2218: PO_DISTRIBUTIONS_AP_V PD,
2219: MTL_SYSTEM_ITEMS MSI
2220: WHERE PLL.LINE_LOCATION_ID = X_PO_LINE_LOCATION_ID
2221: AND PD.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID

Line 3155: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';

3151: END IF;
3152:
3153: END LOOP;
3154:
3155: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
3156: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3157: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3158: END IF;
3159:

Line 3488: po_line_locations pll

3484: --end Bug 7483260
3485: l_retained_amount,
3486: -1 * l_retained_amount
3487: FROM ap_invoice_lines ail1,
3488: po_line_locations pll
3489: WHERE ail1.invoice_id = x_invoice_id
3490: AND ail1.line_number =x_invoice_line_number
3491: AND pll.line_location_id = ail1.po_line_location_id)
3492: WHERE invoice_id = x_invoice_id

Line 4047: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';

4043: END IF;
4044:
4045: END LOOP;
4046:
4047: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
4048: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4049: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
4050: END IF;
4051:

Line 4083: PROCEDURE Update_Corr_Po_Line_Locations(

4079: END Update_Corr_Po_Shipments_Dists;
4080:
4081:
4082:
4083: PROCEDURE Update_Corr_Po_Line_Locations(
4084: x_po_line_location_id IN NUMBER,
4085: x_quantity IN NUMBER,
4086: x_amount IN NUMBER,
4087: x_correction_type IN VARCHAR2,

Line 4097: l_api_name := 'Update_Corr_Po_Line_Locations';

4093: l_api_name VARCHAR2(50);
4094:
4095: BEGIN
4096:
4097: l_api_name := 'Update_Corr_Po_Line_Locations';
4098: current_calling_sequence := ' Update_Corr_Po_Line_Locations<-'||x_calling_sequence;
4099:
4100: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4101: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_Corr_Po_Line_Locations(+)');

Line 4098: current_calling_sequence := ' Update_Corr_Po_Line_Locations<-'||x_calling_sequence;

4094:
4095: BEGIN
4096:
4097: l_api_name := 'Update_Corr_Po_Line_Locations';
4098: current_calling_sequence := ' Update_Corr_Po_Line_Locations<-'||x_calling_sequence;
4099:
4100: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4101: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_Corr_Po_Line_Locations(+)');
4102: END IF;

Line 4101: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_Corr_Po_Line_Locations(+)');

4097: l_api_name := 'Update_Corr_Po_Line_Locations';
4098: current_calling_sequence := ' Update_Corr_Po_Line_Locations<-'||x_calling_sequence;
4099:
4100: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4101: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_Corr_Po_Line_Locations(+)');
4102: END IF;
4103:
4104: l_debug_info := 'Call PO api to update the po_line_location with quantity/amount billed
4105: information';

Line 4113: RCV_BILL_UPDATING_SV.ap_update_po_line_locations(

4109: END IF;
4110:
4111: IF (x_correction_type = 'QTY_CORRECTION') THEN
4112:
4113: RCV_BILL_UPDATING_SV.ap_update_po_line_locations(
4114: x_po_line_location_id => x_po_line_location_id,
4115: x_quantity_billed => x_quantity,
4116: x_uom_lookup_code => x_uom_lookup_code,
4117: x_amount_billed => x_amount, --Modified for bug#9718642 --NULL,

Line 4123: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_Corr_Po_Line_Locations(-)');

4119:
4120: END IF;
4121:
4122: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4123: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_Corr_Po_Line_Locations(-)');
4124: END IF;
4125:
4126:
4127: EXCEPTION

Line 4142: END Update_Corr_Po_Line_Locations;

4138: fnd_message.set_token('DEBUG_INFO',l_debug_info);
4139: End if;
4140: app_exception.raise_exception;
4141:
4142: END Update_Corr_Po_Line_Locations;
4143:
4144:
4145: PROCEDURE Insert_Corr_Invoice_Line(x_invoice_id IN NUMBER,
4146: x_invoice_line_number IN NUMBER,

Line 4490: po_line_locations_ap_v pll

4486: AIL.USER_DEFINED_FISC_CLASS, --user_defined_fisc_class
4487: g_pay_awt_group_id --pay_awt_group_id bug8222382
4488: FROM ap_invoices ai,
4489: ap_invoice_lines ail,
4490: po_line_locations_ap_v pll
4491: WHERE ai.invoice_id = x_corrected_invoice_id
4492: AND ail.invoice_id = ai.invoice_id
4493: AND ail.line_number = x_corrected_line_number
4494: AND pll.line_location_id = ail.po_line_location_id;

Line 5119: FROM po_line_locations_ap_v pll,

5115: pll.product_type product_type,
5116: pll.product_category product_category,
5117: pll.user_defined_fisc_class user_defined_fisc_class
5118: */
5119: FROM po_line_locations_ap_v pll,
5120: mtl_system_items msi
5121: WHERE pll.po_header_id = x_po_header_id
5122: AND msi.inventory_item_id(+) = pll.item_id
5123: AND msi.organization_id(+) = g_inventory_organization_id

Line 5224: l_po_line_location_id po_line_locations.line_location_id%TYPE;

5220: l_available_match_amount NUMBER := x_match_amount;
5221: l_amount ap_invoice_lines.amount%TYPE;
5222: l_base_amount ap_invoice_lines.base_amount%TYPE;
5223: l_quantity ap_invoice_lines.quantity_invoiced%TYPE;
5224: l_po_line_location_id po_line_locations.line_location_id%TYPE;
5225: l_po_line_id po_lines.po_line_id%TYPE;
5226: l_po_release_id po_releases.po_release_id%TYPE;
5227: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE;
5228: l_receipt_uom_lookup_code rcv_shipment_lines.unit_of_measure%TYPE;

Line 5231: l_available_shipment_amount po_line_locations.amount%TYPE;

5227: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE;
5228: l_receipt_uom_lookup_code rcv_shipment_lines.unit_of_measure%TYPE;
5229: l_po_uom_lookup_code po_lines.unit_meas_lookup_code%TYPE;
5230: l_po_unit_price po_lines.unit_price%TYPE;
5231: l_available_shipment_amount po_line_locations.amount%TYPE;
5232: l_item_id po_lines.item_id%TYPE;
5233: l_unit_meas_lookup_code po_lines.unit_meas_lookup_code%TYPE;
5234: l_price_override po_line_locations.price_override%TYPE;
5235: l_item_description po_lines.item_description%TYPE;

Line 5234: l_price_override po_line_locations.price_override%TYPE;

5230: l_po_unit_price po_lines.unit_price%TYPE;
5231: l_available_shipment_amount po_line_locations.amount%TYPE;
5232: l_item_id po_lines.item_id%TYPE;
5233: l_unit_meas_lookup_code po_lines.unit_meas_lookup_code%TYPE;
5234: l_price_override po_line_locations.price_override%TYPE;
5235: l_item_description po_lines.item_description%TYPE;
5236: l_asset_category_id mtl_system_items.asset_category_id%TYPE;
5237: -- Removed for bug 4277744
5238: -- l_ussgl_transaction_code po_line_locations.ussgl_transaction_code%TYPE;

Line 5238: -- l_ussgl_transaction_code po_line_locations.ussgl_transaction_code%TYPE;

5234: l_price_override po_line_locations.price_override%TYPE;
5235: l_item_description po_lines.item_description%TYPE;
5236: l_asset_category_id mtl_system_items.asset_category_id%TYPE;
5237: -- Removed for bug 4277744
5238: -- l_ussgl_transaction_code po_line_locations.ussgl_transaction_code%TYPE;
5239: l_type_1099 po_lines.type_1099%TYPE;
5240: l_attribute_category po_line_locations.attribute_category%TYPE;
5241: l_attribute1 po_line_locations.attribute1%TYPE;
5242: l_attribute2 po_line_locations.attribute2%TYPE;

Line 5240: l_attribute_category po_line_locations.attribute_category%TYPE;

5236: l_asset_category_id mtl_system_items.asset_category_id%TYPE;
5237: -- Removed for bug 4277744
5238: -- l_ussgl_transaction_code po_line_locations.ussgl_transaction_code%TYPE;
5239: l_type_1099 po_lines.type_1099%TYPE;
5240: l_attribute_category po_line_locations.attribute_category%TYPE;
5241: l_attribute1 po_line_locations.attribute1%TYPE;
5242: l_attribute2 po_line_locations.attribute2%TYPE;
5243: l_attribute3 po_line_locations.attribute3%TYPE;
5244: l_attribute4 po_line_locations.attribute4%TYPE;

Line 5241: l_attribute1 po_line_locations.attribute1%TYPE;

5237: -- Removed for bug 4277744
5238: -- l_ussgl_transaction_code po_line_locations.ussgl_transaction_code%TYPE;
5239: l_type_1099 po_lines.type_1099%TYPE;
5240: l_attribute_category po_line_locations.attribute_category%TYPE;
5241: l_attribute1 po_line_locations.attribute1%TYPE;
5242: l_attribute2 po_line_locations.attribute2%TYPE;
5243: l_attribute3 po_line_locations.attribute3%TYPE;
5244: l_attribute4 po_line_locations.attribute4%TYPE;
5245: l_attribute5 po_line_locations.attribute5%TYPE;

Line 5242: l_attribute2 po_line_locations.attribute2%TYPE;

5238: -- l_ussgl_transaction_code po_line_locations.ussgl_transaction_code%TYPE;
5239: l_type_1099 po_lines.type_1099%TYPE;
5240: l_attribute_category po_line_locations.attribute_category%TYPE;
5241: l_attribute1 po_line_locations.attribute1%TYPE;
5242: l_attribute2 po_line_locations.attribute2%TYPE;
5243: l_attribute3 po_line_locations.attribute3%TYPE;
5244: l_attribute4 po_line_locations.attribute4%TYPE;
5245: l_attribute5 po_line_locations.attribute5%TYPE;
5246: l_attribute6 po_line_locations.attribute6%TYPE;

Line 5243: l_attribute3 po_line_locations.attribute3%TYPE;

5239: l_type_1099 po_lines.type_1099%TYPE;
5240: l_attribute_category po_line_locations.attribute_category%TYPE;
5241: l_attribute1 po_line_locations.attribute1%TYPE;
5242: l_attribute2 po_line_locations.attribute2%TYPE;
5243: l_attribute3 po_line_locations.attribute3%TYPE;
5244: l_attribute4 po_line_locations.attribute4%TYPE;
5245: l_attribute5 po_line_locations.attribute5%TYPE;
5246: l_attribute6 po_line_locations.attribute6%TYPE;
5247: l_attribute7 po_line_locations.attribute7%TYPE;

Line 5244: l_attribute4 po_line_locations.attribute4%TYPE;

5240: l_attribute_category po_line_locations.attribute_category%TYPE;
5241: l_attribute1 po_line_locations.attribute1%TYPE;
5242: l_attribute2 po_line_locations.attribute2%TYPE;
5243: l_attribute3 po_line_locations.attribute3%TYPE;
5244: l_attribute4 po_line_locations.attribute4%TYPE;
5245: l_attribute5 po_line_locations.attribute5%TYPE;
5246: l_attribute6 po_line_locations.attribute6%TYPE;
5247: l_attribute7 po_line_locations.attribute7%TYPE;
5248: l_attribute8 po_line_locations.attribute8%TYPE;

Line 5245: l_attribute5 po_line_locations.attribute5%TYPE;

5241: l_attribute1 po_line_locations.attribute1%TYPE;
5242: l_attribute2 po_line_locations.attribute2%TYPE;
5243: l_attribute3 po_line_locations.attribute3%TYPE;
5244: l_attribute4 po_line_locations.attribute4%TYPE;
5245: l_attribute5 po_line_locations.attribute5%TYPE;
5246: l_attribute6 po_line_locations.attribute6%TYPE;
5247: l_attribute7 po_line_locations.attribute7%TYPE;
5248: l_attribute8 po_line_locations.attribute8%TYPE;
5249: l_attribute9 po_line_locations.attribute9%TYPE;

Line 5246: l_attribute6 po_line_locations.attribute6%TYPE;

5242: l_attribute2 po_line_locations.attribute2%TYPE;
5243: l_attribute3 po_line_locations.attribute3%TYPE;
5244: l_attribute4 po_line_locations.attribute4%TYPE;
5245: l_attribute5 po_line_locations.attribute5%TYPE;
5246: l_attribute6 po_line_locations.attribute6%TYPE;
5247: l_attribute7 po_line_locations.attribute7%TYPE;
5248: l_attribute8 po_line_locations.attribute8%TYPE;
5249: l_attribute9 po_line_locations.attribute9%TYPE;
5250: l_attribute10 po_line_locations.attribute10%TYPE;

Line 5247: l_attribute7 po_line_locations.attribute7%TYPE;

5243: l_attribute3 po_line_locations.attribute3%TYPE;
5244: l_attribute4 po_line_locations.attribute4%TYPE;
5245: l_attribute5 po_line_locations.attribute5%TYPE;
5246: l_attribute6 po_line_locations.attribute6%TYPE;
5247: l_attribute7 po_line_locations.attribute7%TYPE;
5248: l_attribute8 po_line_locations.attribute8%TYPE;
5249: l_attribute9 po_line_locations.attribute9%TYPE;
5250: l_attribute10 po_line_locations.attribute10%TYPE;
5251: l_attribute11 po_line_locations.attribute11%TYPE;

Line 5248: l_attribute8 po_line_locations.attribute8%TYPE;

5244: l_attribute4 po_line_locations.attribute4%TYPE;
5245: l_attribute5 po_line_locations.attribute5%TYPE;
5246: l_attribute6 po_line_locations.attribute6%TYPE;
5247: l_attribute7 po_line_locations.attribute7%TYPE;
5248: l_attribute8 po_line_locations.attribute8%TYPE;
5249: l_attribute9 po_line_locations.attribute9%TYPE;
5250: l_attribute10 po_line_locations.attribute10%TYPE;
5251: l_attribute11 po_line_locations.attribute11%TYPE;
5252: l_attribute12 po_line_locations.attribute12%TYPE;

Line 5249: l_attribute9 po_line_locations.attribute9%TYPE;

5245: l_attribute5 po_line_locations.attribute5%TYPE;
5246: l_attribute6 po_line_locations.attribute6%TYPE;
5247: l_attribute7 po_line_locations.attribute7%TYPE;
5248: l_attribute8 po_line_locations.attribute8%TYPE;
5249: l_attribute9 po_line_locations.attribute9%TYPE;
5250: l_attribute10 po_line_locations.attribute10%TYPE;
5251: l_attribute11 po_line_locations.attribute11%TYPE;
5252: l_attribute12 po_line_locations.attribute12%TYPE;
5253: l_attribute13 po_line_locations.attribute13%TYPE;

Line 5250: l_attribute10 po_line_locations.attribute10%TYPE;

5246: l_attribute6 po_line_locations.attribute6%TYPE;
5247: l_attribute7 po_line_locations.attribute7%TYPE;
5248: l_attribute8 po_line_locations.attribute8%TYPE;
5249: l_attribute9 po_line_locations.attribute9%TYPE;
5250: l_attribute10 po_line_locations.attribute10%TYPE;
5251: l_attribute11 po_line_locations.attribute11%TYPE;
5252: l_attribute12 po_line_locations.attribute12%TYPE;
5253: l_attribute13 po_line_locations.attribute13%TYPE;
5254: l_attribute14 po_line_locations.attribute14%TYPE;

Line 5251: l_attribute11 po_line_locations.attribute11%TYPE;

5247: l_attribute7 po_line_locations.attribute7%TYPE;
5248: l_attribute8 po_line_locations.attribute8%TYPE;
5249: l_attribute9 po_line_locations.attribute9%TYPE;
5250: l_attribute10 po_line_locations.attribute10%TYPE;
5251: l_attribute11 po_line_locations.attribute11%TYPE;
5252: l_attribute12 po_line_locations.attribute12%TYPE;
5253: l_attribute13 po_line_locations.attribute13%TYPE;
5254: l_attribute14 po_line_locations.attribute14%TYPE;
5255: l_attribute15 po_line_locations.attribute15%TYPE;

Line 5252: l_attribute12 po_line_locations.attribute12%TYPE;

5248: l_attribute8 po_line_locations.attribute8%TYPE;
5249: l_attribute9 po_line_locations.attribute9%TYPE;
5250: l_attribute10 po_line_locations.attribute10%TYPE;
5251: l_attribute11 po_line_locations.attribute11%TYPE;
5252: l_attribute12 po_line_locations.attribute12%TYPE;
5253: l_attribute13 po_line_locations.attribute13%TYPE;
5254: l_attribute14 po_line_locations.attribute14%TYPE;
5255: l_attribute15 po_line_locations.attribute15%TYPE;
5256: l_invoice_line_number ap_invoice_lines.line_number%TYPE := 1;

Line 5253: l_attribute13 po_line_locations.attribute13%TYPE;

5249: l_attribute9 po_line_locations.attribute9%TYPE;
5250: l_attribute10 po_line_locations.attribute10%TYPE;
5251: l_attribute11 po_line_locations.attribute11%TYPE;
5252: l_attribute12 po_line_locations.attribute12%TYPE;
5253: l_attribute13 po_line_locations.attribute13%TYPE;
5254: l_attribute14 po_line_locations.attribute14%TYPE;
5255: l_attribute15 po_line_locations.attribute15%TYPE;
5256: l_invoice_line_number ap_invoice_lines.line_number%TYPE := 1;
5257: l_index po_line_locations.line_location_id%TYPE;

Line 5254: l_attribute14 po_line_locations.attribute14%TYPE;

5250: l_attribute10 po_line_locations.attribute10%TYPE;
5251: l_attribute11 po_line_locations.attribute11%TYPE;
5252: l_attribute12 po_line_locations.attribute12%TYPE;
5253: l_attribute13 po_line_locations.attribute13%TYPE;
5254: l_attribute14 po_line_locations.attribute14%TYPE;
5255: l_attribute15 po_line_locations.attribute15%TYPE;
5256: l_invoice_line_number ap_invoice_lines.line_number%TYPE := 1;
5257: l_index po_line_locations.line_location_id%TYPE;
5258: l_conversion_factor NUMBER;

Line 5255: l_attribute15 po_line_locations.attribute15%TYPE;

5251: l_attribute11 po_line_locations.attribute11%TYPE;
5252: l_attribute12 po_line_locations.attribute12%TYPE;
5253: l_attribute13 po_line_locations.attribute13%TYPE;
5254: l_attribute14 po_line_locations.attribute14%TYPE;
5255: l_attribute15 po_line_locations.attribute15%TYPE;
5256: l_invoice_line_number ap_invoice_lines.line_number%TYPE := 1;
5257: l_index po_line_locations.line_location_id%TYPE;
5258: l_conversion_factor NUMBER;
5259: l_ordered_qty NUMBER;

Line 5257: l_index po_line_locations.line_location_id%TYPE;

5253: l_attribute13 po_line_locations.attribute13%TYPE;
5254: l_attribute14 po_line_locations.attribute14%TYPE;
5255: l_attribute15 po_line_locations.attribute15%TYPE;
5256: l_invoice_line_number ap_invoice_lines.line_number%TYPE := 1;
5257: l_index po_line_locations.line_location_id%TYPE;
5258: l_conversion_factor NUMBER;
5259: l_ordered_qty NUMBER;
5260: l_cancelled_qty NUMBER;
5261: l_received_qty NUMBER;

Line 5270: l_rounded_index po_line_locations.line_location_id%TYPE;

5266: l_accepted_qty NUMBER;
5267: l_rejected_qty NUMBER;
5268: l_rect_unit_price po_lines.unit_price%TYPE;
5269: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
5270: l_rounded_index po_line_locations.line_location_id%TYPE;
5271: l_sum_prorated_amount ap_invoice_lines.amount%TYPE := 0;
5272: l_available_amount po_line_locations.amount%TYPE;
5273: l_available_qty po_line_locations.quantity%TYPE;
5274: l_invoice_base_amount ap_invoice_lines.base_amount%TYPE := 0;

Line 5272: l_available_amount po_line_locations.amount%TYPE;

5268: l_rect_unit_price po_lines.unit_price%TYPE;
5269: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
5270: l_rounded_index po_line_locations.line_location_id%TYPE;
5271: l_sum_prorated_amount ap_invoice_lines.amount%TYPE := 0;
5272: l_available_amount po_line_locations.amount%TYPE;
5273: l_available_qty po_line_locations.quantity%TYPE;
5274: l_invoice_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5275: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5276: l_ship_to_location_id ap_invoice_lines.ship_to_location_id%TYPE;

Line 5273: l_available_qty po_line_locations.quantity%TYPE;

5269: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
5270: l_rounded_index po_line_locations.line_location_id%TYPE;
5271: l_sum_prorated_amount ap_invoice_lines.amount%TYPE := 0;
5272: l_available_amount po_line_locations.amount%TYPE;
5273: l_available_qty po_line_locations.quantity%TYPE;
5274: l_invoice_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5275: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5276: l_ship_to_location_id ap_invoice_lines.ship_to_location_id%TYPE;
5277: l_primary_intended_use ap_invoice_lines.primary_intended_use%TYPE;

Line 5288: l_matching_basis po_line_locations.matching_basis%TYPE;

5284: l_amount_delivered NUMBER;
5285: l_amount_billed NUMBER;
5286: l_amount_received NUMBER;
5287: l_amount_corrected NUMBER;
5288: l_matching_basis po_line_locations.matching_basis%TYPE;
5289: l_retained_amount ap_invoice_lines.retained_amount%TYPE;
5290: l_ret_status VARCHAR2(100);
5291: l_msg_count NUMBER;
5292: l_msg_data VARCHAR2(250);

Line 5316: l_available_shipment_amt_unrnd po_line_locations.amount%TYPE; --bug 8973086

5312: -- bug 7577673: start
5313: l_allow_tax_code_override varchar2(10);
5314: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
5315: -- bug 7577673: end
5316: l_available_shipment_amt_unrnd po_line_locations.amount%TYPE; --bug 8973086
5317: l_sum_line_amount NUMBER := 0; --bug9802729
5318:
5319: l_code_combination_id NUMBER ; -- Bug 10050094
5320: BEGIN

Line 6383: From po_line_locations_all pll

6379: x_calling_sequence IN VARCHAR2) Is
6380:
6381: Cursor c_line_locations (c_po_header_id NUMBER) IS
6382: Select pll.*
6383: From po_line_locations_all pll
6384: Where pll.po_header_id = c_po_header_id
6385: And nvl(retainage_withheld_amount,0) - nvl(retainage_released_amount,0) <> 0;
6386:
6387: l_line_locations c_line_locations%rowtype;