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:
280: BEGIN
281:

Line 528: po_line_locations pll

524: l_retained_amount,
525: -1 * l_retained_amount
526: FROM ap_invoice_distributions aid,
527: po_distributions pd,
528: po_line_locations pll
529: WHERE aid.invoice_distribution_id = l_invoice_distribution_id
530: AND pd.po_distribution_id = aid.po_distribution_id
531: AND pll.line_location_id = pd.line_location_id)
532: WHERE ail.invoice_id = x_invoice_id

Line 590: po_line_locations pll

586: --end Bug 7483260
587: l_retained_amount,
588: -1 * l_retained_amount
589: FROM ap_invoice_lines ail1,
590: po_line_locations pll
591: WHERE ail1.invoice_id = x_invoice_id
592: AND ail1.line_number =x_invoice_line_number
593: AND pll.line_location_id = ail1.po_line_location_id)
594: WHERE invoice_id = x_invoice_id

Line 908: FROM po_line_locations pll, po_lines pl

904: IF (x_po_line_location_id IS NOT NULL) THEN
905:
906: SELECT pll.shipment_type, pll.po_line_id, pl.recoupment_rate
907: INTO g_shipment_type, g_po_line_id, g_recoupment_rate
908: FROM po_line_locations pll, po_lines pl
909: WHERE pll.line_location_id = x_po_line_location_id
910: AND pll.po_line_id = pl.po_line_id;
911:
912: END IF;

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

1727: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1728: END IF;
1729:
1730: -- bug 5061826
1731: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
1732: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V
1733:
1734: INSERT INTO AP_INVOICE_LINES (
1735: INVOICE_ID,

Line 1732: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V

1728: END IF;
1729:
1730: -- bug 5061826
1731: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
1732: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V
1733:
1734: INSERT INTO AP_INVOICE_LINES (
1735: INVOICE_ID,
1736: LINE_NUMBER,

Line 2106: PO_LINE_LOCATIONS_ALL PLL,

2102: G_dflt_tax_class_code,
2103: G_PAY_AWT_GROUP_ID --pay_awt_group_id bug8222382
2104: -- bug 5061826 -- new FROM clause that goes to base tables
2105: FROM PO_LINES_ALL PL,
2106: PO_LINE_LOCATIONS_ALL PLL,
2107: po_distributions pd,
2108: mtl_system_items msi
2109: WHERE pll.line_location_id = x_po_line_location_id
2110: and pd.line_location_id = pll.line_location_id

Line 2117: FROM PO_LINE_LOCATIONS_AP_V PLL,

2113: and msi.inventory_item_id(+) = pl.item_id
2114: and msi.organization_id(+) = g_inventory_organization_id
2115: and rownum = 1;
2116: /* -- bug 5061826 -- commented out older FROM clause
2117: FROM PO_LINE_LOCATIONS_AP_V PLL,
2118: PO_DISTRIBUTIONS_AP_V PD,
2119: MTL_SYSTEM_ITEMS MSI
2120: WHERE PLL.LINE_LOCATION_ID = X_PO_LINE_LOCATION_ID
2121: AND PD.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID

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

3047: END IF;
3048:
3049: END LOOP;
3050:
3051: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
3052: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3053: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3054: END IF;
3055:

Line 3384: po_line_locations pll

3380: --end Bug 7483260
3381: l_retained_amount,
3382: -1 * l_retained_amount
3383: FROM ap_invoice_lines ail1,
3384: po_line_locations pll
3385: WHERE ail1.invoice_id = x_invoice_id
3386: AND ail1.line_number =x_invoice_line_number
3387: AND pll.line_location_id = ail1.po_line_location_id)
3388: WHERE invoice_id = x_invoice_id

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

3929: END IF;
3930:
3931: END LOOP;
3932:
3933: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
3934: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3935: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3936: END IF;
3937:

Line 3969: PROCEDURE Update_Corr_Po_Line_Locations(

3965: END Update_Corr_Po_Shipments_Dists;
3966:
3967:
3968:
3969: PROCEDURE Update_Corr_Po_Line_Locations(
3970: x_po_line_location_id IN NUMBER,
3971: x_quantity IN NUMBER,
3972: x_amount IN NUMBER,
3973: x_correction_type IN VARCHAR2,

Line 3983: l_api_name := 'Update_Corr_Po_Line_Locations';

3979: l_api_name VARCHAR2(50);
3980:
3981: BEGIN
3982:
3983: l_api_name := 'Update_Corr_Po_Line_Locations';
3984: current_calling_sequence := ' Update_Corr_Po_Line_Locations<-'||x_calling_sequence;
3985:
3986: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3987: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_Corr_Po_Line_Locations(+)');

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

3980:
3981: BEGIN
3982:
3983: l_api_name := 'Update_Corr_Po_Line_Locations';
3984: current_calling_sequence := ' Update_Corr_Po_Line_Locations<-'||x_calling_sequence;
3985:
3986: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3987: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_Corr_Po_Line_Locations(+)');
3988: END IF;

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

3983: l_api_name := 'Update_Corr_Po_Line_Locations';
3984: current_calling_sequence := ' Update_Corr_Po_Line_Locations<-'||x_calling_sequence;
3985:
3986: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3987: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_Corr_Po_Line_Locations(+)');
3988: END IF;
3989:
3990: l_debug_info := 'Call PO api to update the po_line_location with quantity/amount billed
3991: information';

Line 3999: RCV_BILL_UPDATING_SV.ap_update_po_line_locations(

3995: END IF;
3996:
3997: IF (x_correction_type = 'QTY_CORRECTION') THEN
3998:
3999: RCV_BILL_UPDATING_SV.ap_update_po_line_locations(
4000: x_po_line_location_id => x_po_line_location_id,
4001: x_quantity_billed => x_quantity,
4002: x_uom_lookup_code => x_uom_lookup_code,
4003: x_amount_billed => NULL,

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

4005:
4006: END IF;
4007:
4008: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4009: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_Corr_Po_Line_Locations(-)');
4010: END IF;
4011:
4012:
4013: EXCEPTION

Line 4028: END Update_Corr_Po_Line_Locations;

4024: fnd_message.set_token('DEBUG_INFO',l_debug_info);
4025: End if;
4026: app_exception.raise_exception;
4027:
4028: END Update_Corr_Po_Line_Locations;
4029:
4030:
4031: PROCEDURE Insert_Corr_Invoice_Line(x_invoice_id IN NUMBER,
4032: x_invoice_line_number IN NUMBER,

Line 4376: po_line_locations_ap_v pll

4372: AIL.USER_DEFINED_FISC_CLASS, --user_defined_fisc_class
4373: g_pay_awt_group_id --pay_awt_group_id bug8222382
4374: FROM ap_invoices ai,
4375: ap_invoice_lines ail,
4376: po_line_locations_ap_v pll
4377: WHERE ai.invoice_id = x_corrected_invoice_id
4378: AND ail.invoice_id = ai.invoice_id
4379: AND ail.line_number = x_corrected_line_number
4380: AND pll.line_location_id = ail.po_line_location_id;

Line 4995: FROM po_line_locations_ap_v pll,

4991: pll.product_type product_type,
4992: pll.product_category product_category,
4993: pll.user_defined_fisc_class user_defined_fisc_class
4994: */
4995: FROM po_line_locations_ap_v pll,
4996: mtl_system_items msi
4997: WHERE pll.po_header_id = x_po_header_id
4998: AND msi.inventory_item_id(+) = pll.item_id
4999: AND msi.organization_id(+) = g_inventory_organization_id

Line 5099: l_po_line_location_id po_line_locations.line_location_id%TYPE;

5095: l_available_match_amount NUMBER := x_match_amount;
5096: l_amount ap_invoice_lines.amount%TYPE;
5097: l_base_amount ap_invoice_lines.base_amount%TYPE;
5098: l_quantity ap_invoice_lines.quantity_invoiced%TYPE;
5099: l_po_line_location_id po_line_locations.line_location_id%TYPE;
5100: l_po_line_id po_lines.po_line_id%TYPE;
5101: l_po_release_id po_releases.po_release_id%TYPE;
5102: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE;
5103: l_receipt_uom_lookup_code rcv_shipment_lines.unit_of_measure%TYPE;

Line 5106: l_available_shipment_amount po_line_locations.amount%TYPE;

5102: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE;
5103: l_receipt_uom_lookup_code rcv_shipment_lines.unit_of_measure%TYPE;
5104: l_po_uom_lookup_code po_lines.unit_meas_lookup_code%TYPE;
5105: l_po_unit_price po_lines.unit_price%TYPE;
5106: l_available_shipment_amount po_line_locations.amount%TYPE;
5107: l_item_id po_lines.item_id%TYPE;
5108: l_unit_meas_lookup_code po_lines.unit_meas_lookup_code%TYPE;
5109: l_price_override po_line_locations.price_override%TYPE;
5110: l_item_description po_lines.item_description%TYPE;

Line 5109: l_price_override po_line_locations.price_override%TYPE;

5105: l_po_unit_price po_lines.unit_price%TYPE;
5106: l_available_shipment_amount po_line_locations.amount%TYPE;
5107: l_item_id po_lines.item_id%TYPE;
5108: l_unit_meas_lookup_code po_lines.unit_meas_lookup_code%TYPE;
5109: l_price_override po_line_locations.price_override%TYPE;
5110: l_item_description po_lines.item_description%TYPE;
5111: l_asset_category_id mtl_system_items.asset_category_id%TYPE;
5112: -- Removed for bug 4277744
5113: -- l_ussgl_transaction_code po_line_locations.ussgl_transaction_code%TYPE;

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

5109: l_price_override po_line_locations.price_override%TYPE;
5110: l_item_description po_lines.item_description%TYPE;
5111: l_asset_category_id mtl_system_items.asset_category_id%TYPE;
5112: -- Removed for bug 4277744
5113: -- l_ussgl_transaction_code po_line_locations.ussgl_transaction_code%TYPE;
5114: l_type_1099 po_lines.type_1099%TYPE;
5115: l_attribute_category po_line_locations.attribute_category%TYPE;
5116: l_attribute1 po_line_locations.attribute1%TYPE;
5117: l_attribute2 po_line_locations.attribute2%TYPE;

Line 5115: l_attribute_category po_line_locations.attribute_category%TYPE;

5111: l_asset_category_id mtl_system_items.asset_category_id%TYPE;
5112: -- Removed for bug 4277744
5113: -- l_ussgl_transaction_code po_line_locations.ussgl_transaction_code%TYPE;
5114: l_type_1099 po_lines.type_1099%TYPE;
5115: l_attribute_category po_line_locations.attribute_category%TYPE;
5116: l_attribute1 po_line_locations.attribute1%TYPE;
5117: l_attribute2 po_line_locations.attribute2%TYPE;
5118: l_attribute3 po_line_locations.attribute3%TYPE;
5119: l_attribute4 po_line_locations.attribute4%TYPE;

Line 5116: l_attribute1 po_line_locations.attribute1%TYPE;

5112: -- Removed for bug 4277744
5113: -- l_ussgl_transaction_code po_line_locations.ussgl_transaction_code%TYPE;
5114: l_type_1099 po_lines.type_1099%TYPE;
5115: l_attribute_category po_line_locations.attribute_category%TYPE;
5116: l_attribute1 po_line_locations.attribute1%TYPE;
5117: l_attribute2 po_line_locations.attribute2%TYPE;
5118: l_attribute3 po_line_locations.attribute3%TYPE;
5119: l_attribute4 po_line_locations.attribute4%TYPE;
5120: l_attribute5 po_line_locations.attribute5%TYPE;

Line 5117: l_attribute2 po_line_locations.attribute2%TYPE;

5113: -- l_ussgl_transaction_code po_line_locations.ussgl_transaction_code%TYPE;
5114: l_type_1099 po_lines.type_1099%TYPE;
5115: l_attribute_category po_line_locations.attribute_category%TYPE;
5116: l_attribute1 po_line_locations.attribute1%TYPE;
5117: l_attribute2 po_line_locations.attribute2%TYPE;
5118: l_attribute3 po_line_locations.attribute3%TYPE;
5119: l_attribute4 po_line_locations.attribute4%TYPE;
5120: l_attribute5 po_line_locations.attribute5%TYPE;
5121: l_attribute6 po_line_locations.attribute6%TYPE;

Line 5118: l_attribute3 po_line_locations.attribute3%TYPE;

5114: l_type_1099 po_lines.type_1099%TYPE;
5115: l_attribute_category po_line_locations.attribute_category%TYPE;
5116: l_attribute1 po_line_locations.attribute1%TYPE;
5117: l_attribute2 po_line_locations.attribute2%TYPE;
5118: l_attribute3 po_line_locations.attribute3%TYPE;
5119: l_attribute4 po_line_locations.attribute4%TYPE;
5120: l_attribute5 po_line_locations.attribute5%TYPE;
5121: l_attribute6 po_line_locations.attribute6%TYPE;
5122: l_attribute7 po_line_locations.attribute7%TYPE;

Line 5119: l_attribute4 po_line_locations.attribute4%TYPE;

5115: l_attribute_category po_line_locations.attribute_category%TYPE;
5116: l_attribute1 po_line_locations.attribute1%TYPE;
5117: l_attribute2 po_line_locations.attribute2%TYPE;
5118: l_attribute3 po_line_locations.attribute3%TYPE;
5119: l_attribute4 po_line_locations.attribute4%TYPE;
5120: l_attribute5 po_line_locations.attribute5%TYPE;
5121: l_attribute6 po_line_locations.attribute6%TYPE;
5122: l_attribute7 po_line_locations.attribute7%TYPE;
5123: l_attribute8 po_line_locations.attribute8%TYPE;

Line 5120: l_attribute5 po_line_locations.attribute5%TYPE;

5116: l_attribute1 po_line_locations.attribute1%TYPE;
5117: l_attribute2 po_line_locations.attribute2%TYPE;
5118: l_attribute3 po_line_locations.attribute3%TYPE;
5119: l_attribute4 po_line_locations.attribute4%TYPE;
5120: l_attribute5 po_line_locations.attribute5%TYPE;
5121: l_attribute6 po_line_locations.attribute6%TYPE;
5122: l_attribute7 po_line_locations.attribute7%TYPE;
5123: l_attribute8 po_line_locations.attribute8%TYPE;
5124: l_attribute9 po_line_locations.attribute9%TYPE;

Line 5121: l_attribute6 po_line_locations.attribute6%TYPE;

5117: l_attribute2 po_line_locations.attribute2%TYPE;
5118: l_attribute3 po_line_locations.attribute3%TYPE;
5119: l_attribute4 po_line_locations.attribute4%TYPE;
5120: l_attribute5 po_line_locations.attribute5%TYPE;
5121: l_attribute6 po_line_locations.attribute6%TYPE;
5122: l_attribute7 po_line_locations.attribute7%TYPE;
5123: l_attribute8 po_line_locations.attribute8%TYPE;
5124: l_attribute9 po_line_locations.attribute9%TYPE;
5125: l_attribute10 po_line_locations.attribute10%TYPE;

Line 5122: l_attribute7 po_line_locations.attribute7%TYPE;

5118: l_attribute3 po_line_locations.attribute3%TYPE;
5119: l_attribute4 po_line_locations.attribute4%TYPE;
5120: l_attribute5 po_line_locations.attribute5%TYPE;
5121: l_attribute6 po_line_locations.attribute6%TYPE;
5122: l_attribute7 po_line_locations.attribute7%TYPE;
5123: l_attribute8 po_line_locations.attribute8%TYPE;
5124: l_attribute9 po_line_locations.attribute9%TYPE;
5125: l_attribute10 po_line_locations.attribute10%TYPE;
5126: l_attribute11 po_line_locations.attribute11%TYPE;

Line 5123: l_attribute8 po_line_locations.attribute8%TYPE;

5119: l_attribute4 po_line_locations.attribute4%TYPE;
5120: l_attribute5 po_line_locations.attribute5%TYPE;
5121: l_attribute6 po_line_locations.attribute6%TYPE;
5122: l_attribute7 po_line_locations.attribute7%TYPE;
5123: l_attribute8 po_line_locations.attribute8%TYPE;
5124: l_attribute9 po_line_locations.attribute9%TYPE;
5125: l_attribute10 po_line_locations.attribute10%TYPE;
5126: l_attribute11 po_line_locations.attribute11%TYPE;
5127: l_attribute12 po_line_locations.attribute12%TYPE;

Line 5124: l_attribute9 po_line_locations.attribute9%TYPE;

5120: l_attribute5 po_line_locations.attribute5%TYPE;
5121: l_attribute6 po_line_locations.attribute6%TYPE;
5122: l_attribute7 po_line_locations.attribute7%TYPE;
5123: l_attribute8 po_line_locations.attribute8%TYPE;
5124: l_attribute9 po_line_locations.attribute9%TYPE;
5125: l_attribute10 po_line_locations.attribute10%TYPE;
5126: l_attribute11 po_line_locations.attribute11%TYPE;
5127: l_attribute12 po_line_locations.attribute12%TYPE;
5128: l_attribute13 po_line_locations.attribute13%TYPE;

Line 5125: l_attribute10 po_line_locations.attribute10%TYPE;

5121: l_attribute6 po_line_locations.attribute6%TYPE;
5122: l_attribute7 po_line_locations.attribute7%TYPE;
5123: l_attribute8 po_line_locations.attribute8%TYPE;
5124: l_attribute9 po_line_locations.attribute9%TYPE;
5125: l_attribute10 po_line_locations.attribute10%TYPE;
5126: l_attribute11 po_line_locations.attribute11%TYPE;
5127: l_attribute12 po_line_locations.attribute12%TYPE;
5128: l_attribute13 po_line_locations.attribute13%TYPE;
5129: l_attribute14 po_line_locations.attribute14%TYPE;

Line 5126: l_attribute11 po_line_locations.attribute11%TYPE;

5122: l_attribute7 po_line_locations.attribute7%TYPE;
5123: l_attribute8 po_line_locations.attribute8%TYPE;
5124: l_attribute9 po_line_locations.attribute9%TYPE;
5125: l_attribute10 po_line_locations.attribute10%TYPE;
5126: l_attribute11 po_line_locations.attribute11%TYPE;
5127: l_attribute12 po_line_locations.attribute12%TYPE;
5128: l_attribute13 po_line_locations.attribute13%TYPE;
5129: l_attribute14 po_line_locations.attribute14%TYPE;
5130: l_attribute15 po_line_locations.attribute15%TYPE;

Line 5127: l_attribute12 po_line_locations.attribute12%TYPE;

5123: l_attribute8 po_line_locations.attribute8%TYPE;
5124: l_attribute9 po_line_locations.attribute9%TYPE;
5125: l_attribute10 po_line_locations.attribute10%TYPE;
5126: l_attribute11 po_line_locations.attribute11%TYPE;
5127: l_attribute12 po_line_locations.attribute12%TYPE;
5128: l_attribute13 po_line_locations.attribute13%TYPE;
5129: l_attribute14 po_line_locations.attribute14%TYPE;
5130: l_attribute15 po_line_locations.attribute15%TYPE;
5131: l_invoice_line_number ap_invoice_lines.line_number%TYPE := 1;

Line 5128: l_attribute13 po_line_locations.attribute13%TYPE;

5124: l_attribute9 po_line_locations.attribute9%TYPE;
5125: l_attribute10 po_line_locations.attribute10%TYPE;
5126: l_attribute11 po_line_locations.attribute11%TYPE;
5127: l_attribute12 po_line_locations.attribute12%TYPE;
5128: l_attribute13 po_line_locations.attribute13%TYPE;
5129: l_attribute14 po_line_locations.attribute14%TYPE;
5130: l_attribute15 po_line_locations.attribute15%TYPE;
5131: l_invoice_line_number ap_invoice_lines.line_number%TYPE := 1;
5132: l_index po_line_locations.line_location_id%TYPE;

Line 5129: l_attribute14 po_line_locations.attribute14%TYPE;

5125: l_attribute10 po_line_locations.attribute10%TYPE;
5126: l_attribute11 po_line_locations.attribute11%TYPE;
5127: l_attribute12 po_line_locations.attribute12%TYPE;
5128: l_attribute13 po_line_locations.attribute13%TYPE;
5129: l_attribute14 po_line_locations.attribute14%TYPE;
5130: l_attribute15 po_line_locations.attribute15%TYPE;
5131: l_invoice_line_number ap_invoice_lines.line_number%TYPE := 1;
5132: l_index po_line_locations.line_location_id%TYPE;
5133: l_conversion_factor NUMBER;

Line 5130: l_attribute15 po_line_locations.attribute15%TYPE;

5126: l_attribute11 po_line_locations.attribute11%TYPE;
5127: l_attribute12 po_line_locations.attribute12%TYPE;
5128: l_attribute13 po_line_locations.attribute13%TYPE;
5129: l_attribute14 po_line_locations.attribute14%TYPE;
5130: l_attribute15 po_line_locations.attribute15%TYPE;
5131: l_invoice_line_number ap_invoice_lines.line_number%TYPE := 1;
5132: l_index po_line_locations.line_location_id%TYPE;
5133: l_conversion_factor NUMBER;
5134: l_ordered_qty NUMBER;

Line 5132: l_index po_line_locations.line_location_id%TYPE;

5128: l_attribute13 po_line_locations.attribute13%TYPE;
5129: l_attribute14 po_line_locations.attribute14%TYPE;
5130: l_attribute15 po_line_locations.attribute15%TYPE;
5131: l_invoice_line_number ap_invoice_lines.line_number%TYPE := 1;
5132: l_index po_line_locations.line_location_id%TYPE;
5133: l_conversion_factor NUMBER;
5134: l_ordered_qty NUMBER;
5135: l_cancelled_qty NUMBER;
5136: l_received_qty NUMBER;

Line 5145: l_rounded_index po_line_locations.line_location_id%TYPE;

5141: l_accepted_qty NUMBER;
5142: l_rejected_qty NUMBER;
5143: l_rect_unit_price po_lines.unit_price%TYPE;
5144: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
5145: l_rounded_index po_line_locations.line_location_id%TYPE;
5146: l_sum_prorated_amount ap_invoice_lines.amount%TYPE := 0;
5147: l_available_amount po_line_locations.amount%TYPE;
5148: l_available_qty po_line_locations.quantity%TYPE;
5149: l_invoice_base_amount ap_invoice_lines.base_amount%TYPE := 0;

Line 5147: l_available_amount po_line_locations.amount%TYPE;

5143: l_rect_unit_price po_lines.unit_price%TYPE;
5144: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
5145: l_rounded_index po_line_locations.line_location_id%TYPE;
5146: l_sum_prorated_amount ap_invoice_lines.amount%TYPE := 0;
5147: l_available_amount po_line_locations.amount%TYPE;
5148: l_available_qty po_line_locations.quantity%TYPE;
5149: l_invoice_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5150: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5151: l_ship_to_location_id ap_invoice_lines.ship_to_location_id%TYPE;

Line 5148: l_available_qty po_line_locations.quantity%TYPE;

5144: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
5145: l_rounded_index po_line_locations.line_location_id%TYPE;
5146: l_sum_prorated_amount ap_invoice_lines.amount%TYPE := 0;
5147: l_available_amount po_line_locations.amount%TYPE;
5148: l_available_qty po_line_locations.quantity%TYPE;
5149: l_invoice_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5150: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5151: l_ship_to_location_id ap_invoice_lines.ship_to_location_id%TYPE;
5152: l_primary_intended_use ap_invoice_lines.primary_intended_use%TYPE;

Line 5163: l_matching_basis po_line_locations.matching_basis%TYPE;

5159: l_amount_delivered NUMBER;
5160: l_amount_billed NUMBER;
5161: l_amount_received NUMBER;
5162: l_amount_corrected NUMBER;
5163: l_matching_basis po_line_locations.matching_basis%TYPE;
5164: l_retained_amount ap_invoice_lines.retained_amount%TYPE;
5165: l_ret_status VARCHAR2(100);
5166: l_msg_count NUMBER;
5167: l_msg_data VARCHAR2(250);

Line 6034: From po_line_locations_all pll

6030: x_calling_sequence IN VARCHAR2) Is
6031:
6032: Cursor c_line_locations (c_po_header_id NUMBER) IS
6033: Select pll.*
6034: From po_line_locations_all pll
6035: Where pll.po_header_id = c_po_header_id
6036: And nvl(retainage_withheld_amount,0) - nvl(retainage_released_amount,0) <> 0;
6037:
6038: l_line_locations c_line_locations%rowtype;