APPS.JAI_AP_MATCH_TAX_PROC_PKG dependencies on AP_INVOICE_LINES_ALL

Line 314: r_ap_inv_line_item ap_invoice_lines_all%ROWTYPE;

310: ,pv_rematch VARCHAR2
311: ,pn_shipment_hdr_id NUMBER
312: ,pn_shipment_line_id NUMBER
313: )IS
314: r_ap_inv_line_item ap_invoice_lines_all%ROWTYPE;
315: r_ap_inv_dist_item ap_invoice_distributions_all%ROWTYPE;
316: r_ap_inv_dist_tax ap_invoice_distributions_all%ROWTYPE;
317: lv_tax_type VARCHAR2(10);
318: lv_is_item_an_expense VARCHAR2(1);

Line 332: ap_invoice_lines_all

328: ln_incls_acct_id NUMBER;
329: ln_cum_tax_amt NUMBER;
330: CURSOR c_inv_line IS
331: SELECT * FROM
332: ap_invoice_lines_all
333: WHERE invoice_id = Pn_invoice_id
334: AND LINE_NUMBER = pn_invoice_line_num;
335:
336: CURSOR c_inv_dist IS

Line 592: ap_invoice_lines_all b

588: ,project_accounting_context
589: ,pa_addition_flag
590: ,a.dist_match_type
591: FROM ap_invoice_distributions_all a,
592: ap_invoice_lines_all b
593: WHERE a.invoice_id = ln_invoice_id
594: AND a.invoice_line_number = pr_ap_inv_line_item.line_number
595: AND b.invoice_id = ln_invoice_id
596: AND b.line_number = pr_ap_inv_line_item.line_number

Line 654: FROM ap_invoice_lines_all

650: END IF;
651: -- Cursor to select maximum line number from invoice lines for particular invoice
652: SELECT max(line_number)
653: INTO ln_inv_line_num
654: FROM ap_invoice_lines_all
655: WHERE invoice_id = ln_invoice_id;
656:
657: if ln_tax_precision is null then
658: ln_tax_precision := -1;

Line 1023: jai_ap_match_tax_proc_pkg.insert_ap_inv_line( p_ap_invoice_lines_all_rec => lr_ap_inv_line_tax);

1019: lr_ap_inv_line_tax.product_table := G_MATCH_PRODUCT_TABLE;
1020: lr_ap_inv_line_tax.reference_key1 := p_tax_line_rec.tax_id;
1021: lr_ap_inv_line_tax.reference_key2 := pr_ap_inv_line_item.line_number;
1022: END IF;
1023: jai_ap_match_tax_proc_pkg.insert_ap_inv_line( p_ap_invoice_lines_all_rec => lr_ap_inv_line_tax);
1024:
1025:
1026: END IF;
1027:

Line 1344: Fnd_File.put_line(Fnd_File.LOG,'Before inserting Inclusive Service tax lines for POT into ap_invoice_lines_all for line no :'

1340: --when insert jai_ap_match_inv_taxes used; for the negative line, will use ln_inv_line_num + 1 as
1341: --line number.
1342:
1343:
1344: Fnd_File.put_line(Fnd_File.LOG,'Before inserting Inclusive Service tax lines for POT into ap_invoice_lines_all for line no :'
1345: || ln_inv_line_num ||' tax amount = '||lv_tax_line_amount);
1346: lr_ap_inv_line_incl_tax := lr_ap_inv_line_tax;
1347:
1348: lr_ap_inv_line_incl_tax.invoice_id := ln_invoice_id;

Line 1392: jai_ap_match_tax_proc_pkg.insert_ap_inv_line( p_ap_invoice_lines_all_rec => lr_ap_inv_line_incl_tax);

1388: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'Before inserting
1389: Inclusive Service tax lines for POT into ap_line ');
1390: END IF;
1391:
1392: jai_ap_match_tax_proc_pkg.insert_ap_inv_line( p_ap_invoice_lines_all_rec => lr_ap_inv_line_incl_tax);
1393:
1394: lr_ap_inv_dist_incl_tax := pr_ap_inv_dist_tax;
1395: lr_ap_inv_dist_incl_tax.assets_tracking_flag := nvl(v_assets_tracking_flag,pr_ap_inv_dist_tax.assets_tracking_flag);
1396: lr_ap_inv_dist_incl_tax.invoice_id := ln_invoice_id;

Line 1444: jai_ap_match_tax_proc_pkg.insert_ap_inv_line( p_ap_invoice_lines_all_rec => lr_ap_inv_line_liability);

1440: IF p_tax_line_rec.reverse_charge_flag = 'Y' THEN
1441: ln_inv_line_num := ln_inv_line_num + 1;
1442: lr_ap_inv_line_liability.amount := -abs(lr_ap_inv_line_liability.amount);
1443: lr_ap_inv_line_liability.LINE_NUMBER := ln_inv_line_num;
1444: jai_ap_match_tax_proc_pkg.insert_ap_inv_line( p_ap_invoice_lines_all_rec => lr_ap_inv_line_liability);
1445:
1446: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1447: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'insert_ap_inv_line liability line for reverse charge with amt:'||lr_ap_inv_line_liability.amount);
1448: END IF;

Line 2089: p_ap_invoice_lines_all_rec IN ap_invoice_lines_all%ROWTYPE

2085:
2086: END insert_jai_ap_match;
2087:
2088: PROCEDURE insert_ap_inv_line(
2089: p_ap_invoice_lines_all_rec IN ap_invoice_lines_all%ROWTYPE
2090: )IS
2091: l_api_name CONSTANT VARCHAR2(50) := 'insert_ap_inv_line()';
2092: BEGIN
2093: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2095: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'invoice line num: '||p_ap_invoice_lines_all_rec.LINE_NUMBER);

2091: l_api_name CONSTANT VARCHAR2(50) := 'insert_ap_inv_line()';
2092: BEGIN
2093: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2094: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2095: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'invoice line num: '||p_ap_invoice_lines_all_rec.LINE_NUMBER);
2096: END IF;
2097:
2098: INSERT INTO ap_invoice_lines_all
2099: (INVOICE_ID

Line 2098: INSERT INTO ap_invoice_lines_all

2094: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2095: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'invoice line num: '||p_ap_invoice_lines_all_rec.LINE_NUMBER);
2096: END IF;
2097:
2098: INSERT INTO ap_invoice_lines_all
2099: (INVOICE_ID
2100: ,LINE_NUMBER
2101: ,LINE_TYPE_LOOKUP_CODE
2102: ,REQUESTER_ID

Line 2303: (p_ap_invoice_lines_all_rec.INVOICE_ID

2299: ,AIL_INVOICE_ID4
2300: ,PAY_AWT_GROUP_ID
2301: )
2302: VALUES
2303: (p_ap_invoice_lines_all_rec.INVOICE_ID
2304: ,p_ap_invoice_lines_all_rec.LINE_NUMBER
2305: ,p_ap_invoice_lines_all_rec.LINE_TYPE_LOOKUP_CODE
2306: ,p_ap_invoice_lines_all_rec.REQUESTER_ID
2307: ,p_ap_invoice_lines_all_rec.DESCRIPTION

Line 2304: ,p_ap_invoice_lines_all_rec.LINE_NUMBER

2300: ,PAY_AWT_GROUP_ID
2301: )
2302: VALUES
2303: (p_ap_invoice_lines_all_rec.INVOICE_ID
2304: ,p_ap_invoice_lines_all_rec.LINE_NUMBER
2305: ,p_ap_invoice_lines_all_rec.LINE_TYPE_LOOKUP_CODE
2306: ,p_ap_invoice_lines_all_rec.REQUESTER_ID
2307: ,p_ap_invoice_lines_all_rec.DESCRIPTION
2308: ,p_ap_invoice_lines_all_rec.LINE_SOURCE

Line 2305: ,p_ap_invoice_lines_all_rec.LINE_TYPE_LOOKUP_CODE

2301: )
2302: VALUES
2303: (p_ap_invoice_lines_all_rec.INVOICE_ID
2304: ,p_ap_invoice_lines_all_rec.LINE_NUMBER
2305: ,p_ap_invoice_lines_all_rec.LINE_TYPE_LOOKUP_CODE
2306: ,p_ap_invoice_lines_all_rec.REQUESTER_ID
2307: ,p_ap_invoice_lines_all_rec.DESCRIPTION
2308: ,p_ap_invoice_lines_all_rec.LINE_SOURCE
2309: ,p_ap_invoice_lines_all_rec.ORG_ID

Line 2306: ,p_ap_invoice_lines_all_rec.REQUESTER_ID

2302: VALUES
2303: (p_ap_invoice_lines_all_rec.INVOICE_ID
2304: ,p_ap_invoice_lines_all_rec.LINE_NUMBER
2305: ,p_ap_invoice_lines_all_rec.LINE_TYPE_LOOKUP_CODE
2306: ,p_ap_invoice_lines_all_rec.REQUESTER_ID
2307: ,p_ap_invoice_lines_all_rec.DESCRIPTION
2308: ,p_ap_invoice_lines_all_rec.LINE_SOURCE
2309: ,p_ap_invoice_lines_all_rec.ORG_ID
2310: ,p_ap_invoice_lines_all_rec.LINE_GROUP_NUMBER

Line 2307: ,p_ap_invoice_lines_all_rec.DESCRIPTION

2303: (p_ap_invoice_lines_all_rec.INVOICE_ID
2304: ,p_ap_invoice_lines_all_rec.LINE_NUMBER
2305: ,p_ap_invoice_lines_all_rec.LINE_TYPE_LOOKUP_CODE
2306: ,p_ap_invoice_lines_all_rec.REQUESTER_ID
2307: ,p_ap_invoice_lines_all_rec.DESCRIPTION
2308: ,p_ap_invoice_lines_all_rec.LINE_SOURCE
2309: ,p_ap_invoice_lines_all_rec.ORG_ID
2310: ,p_ap_invoice_lines_all_rec.LINE_GROUP_NUMBER
2311: ,p_ap_invoice_lines_all_rec.INVENTORY_ITEM_ID

Line 2308: ,p_ap_invoice_lines_all_rec.LINE_SOURCE

2304: ,p_ap_invoice_lines_all_rec.LINE_NUMBER
2305: ,p_ap_invoice_lines_all_rec.LINE_TYPE_LOOKUP_CODE
2306: ,p_ap_invoice_lines_all_rec.REQUESTER_ID
2307: ,p_ap_invoice_lines_all_rec.DESCRIPTION
2308: ,p_ap_invoice_lines_all_rec.LINE_SOURCE
2309: ,p_ap_invoice_lines_all_rec.ORG_ID
2310: ,p_ap_invoice_lines_all_rec.LINE_GROUP_NUMBER
2311: ,p_ap_invoice_lines_all_rec.INVENTORY_ITEM_ID
2312: ,p_ap_invoice_lines_all_rec.ITEM_DESCRIPTION

Line 2309: ,p_ap_invoice_lines_all_rec.ORG_ID

2305: ,p_ap_invoice_lines_all_rec.LINE_TYPE_LOOKUP_CODE
2306: ,p_ap_invoice_lines_all_rec.REQUESTER_ID
2307: ,p_ap_invoice_lines_all_rec.DESCRIPTION
2308: ,p_ap_invoice_lines_all_rec.LINE_SOURCE
2309: ,p_ap_invoice_lines_all_rec.ORG_ID
2310: ,p_ap_invoice_lines_all_rec.LINE_GROUP_NUMBER
2311: ,p_ap_invoice_lines_all_rec.INVENTORY_ITEM_ID
2312: ,p_ap_invoice_lines_all_rec.ITEM_DESCRIPTION
2313: ,p_ap_invoice_lines_all_rec.SERIAL_NUMBER

Line 2310: ,p_ap_invoice_lines_all_rec.LINE_GROUP_NUMBER

2306: ,p_ap_invoice_lines_all_rec.REQUESTER_ID
2307: ,p_ap_invoice_lines_all_rec.DESCRIPTION
2308: ,p_ap_invoice_lines_all_rec.LINE_SOURCE
2309: ,p_ap_invoice_lines_all_rec.ORG_ID
2310: ,p_ap_invoice_lines_all_rec.LINE_GROUP_NUMBER
2311: ,p_ap_invoice_lines_all_rec.INVENTORY_ITEM_ID
2312: ,p_ap_invoice_lines_all_rec.ITEM_DESCRIPTION
2313: ,p_ap_invoice_lines_all_rec.SERIAL_NUMBER
2314: ,p_ap_invoice_lines_all_rec.MANUFACTURER

Line 2311: ,p_ap_invoice_lines_all_rec.INVENTORY_ITEM_ID

2307: ,p_ap_invoice_lines_all_rec.DESCRIPTION
2308: ,p_ap_invoice_lines_all_rec.LINE_SOURCE
2309: ,p_ap_invoice_lines_all_rec.ORG_ID
2310: ,p_ap_invoice_lines_all_rec.LINE_GROUP_NUMBER
2311: ,p_ap_invoice_lines_all_rec.INVENTORY_ITEM_ID
2312: ,p_ap_invoice_lines_all_rec.ITEM_DESCRIPTION
2313: ,p_ap_invoice_lines_all_rec.SERIAL_NUMBER
2314: ,p_ap_invoice_lines_all_rec.MANUFACTURER
2315: ,p_ap_invoice_lines_all_rec.MODEL_NUMBER

Line 2312: ,p_ap_invoice_lines_all_rec.ITEM_DESCRIPTION

2308: ,p_ap_invoice_lines_all_rec.LINE_SOURCE
2309: ,p_ap_invoice_lines_all_rec.ORG_ID
2310: ,p_ap_invoice_lines_all_rec.LINE_GROUP_NUMBER
2311: ,p_ap_invoice_lines_all_rec.INVENTORY_ITEM_ID
2312: ,p_ap_invoice_lines_all_rec.ITEM_DESCRIPTION
2313: ,p_ap_invoice_lines_all_rec.SERIAL_NUMBER
2314: ,p_ap_invoice_lines_all_rec.MANUFACTURER
2315: ,p_ap_invoice_lines_all_rec.MODEL_NUMBER
2316: ,p_ap_invoice_lines_all_rec.WARRANTY_NUMBER

Line 2313: ,p_ap_invoice_lines_all_rec.SERIAL_NUMBER

2309: ,p_ap_invoice_lines_all_rec.ORG_ID
2310: ,p_ap_invoice_lines_all_rec.LINE_GROUP_NUMBER
2311: ,p_ap_invoice_lines_all_rec.INVENTORY_ITEM_ID
2312: ,p_ap_invoice_lines_all_rec.ITEM_DESCRIPTION
2313: ,p_ap_invoice_lines_all_rec.SERIAL_NUMBER
2314: ,p_ap_invoice_lines_all_rec.MANUFACTURER
2315: ,p_ap_invoice_lines_all_rec.MODEL_NUMBER
2316: ,p_ap_invoice_lines_all_rec.WARRANTY_NUMBER
2317: ,p_ap_invoice_lines_all_rec.GENERATE_DISTS

Line 2314: ,p_ap_invoice_lines_all_rec.MANUFACTURER

2310: ,p_ap_invoice_lines_all_rec.LINE_GROUP_NUMBER
2311: ,p_ap_invoice_lines_all_rec.INVENTORY_ITEM_ID
2312: ,p_ap_invoice_lines_all_rec.ITEM_DESCRIPTION
2313: ,p_ap_invoice_lines_all_rec.SERIAL_NUMBER
2314: ,p_ap_invoice_lines_all_rec.MANUFACTURER
2315: ,p_ap_invoice_lines_all_rec.MODEL_NUMBER
2316: ,p_ap_invoice_lines_all_rec.WARRANTY_NUMBER
2317: ,p_ap_invoice_lines_all_rec.GENERATE_DISTS
2318: ,p_ap_invoice_lines_all_rec.MATCH_TYPE

Line 2315: ,p_ap_invoice_lines_all_rec.MODEL_NUMBER

2311: ,p_ap_invoice_lines_all_rec.INVENTORY_ITEM_ID
2312: ,p_ap_invoice_lines_all_rec.ITEM_DESCRIPTION
2313: ,p_ap_invoice_lines_all_rec.SERIAL_NUMBER
2314: ,p_ap_invoice_lines_all_rec.MANUFACTURER
2315: ,p_ap_invoice_lines_all_rec.MODEL_NUMBER
2316: ,p_ap_invoice_lines_all_rec.WARRANTY_NUMBER
2317: ,p_ap_invoice_lines_all_rec.GENERATE_DISTS
2318: ,p_ap_invoice_lines_all_rec.MATCH_TYPE
2319: ,p_ap_invoice_lines_all_rec.DISTRIBUTION_SET_ID

Line 2316: ,p_ap_invoice_lines_all_rec.WARRANTY_NUMBER

2312: ,p_ap_invoice_lines_all_rec.ITEM_DESCRIPTION
2313: ,p_ap_invoice_lines_all_rec.SERIAL_NUMBER
2314: ,p_ap_invoice_lines_all_rec.MANUFACTURER
2315: ,p_ap_invoice_lines_all_rec.MODEL_NUMBER
2316: ,p_ap_invoice_lines_all_rec.WARRANTY_NUMBER
2317: ,p_ap_invoice_lines_all_rec.GENERATE_DISTS
2318: ,p_ap_invoice_lines_all_rec.MATCH_TYPE
2319: ,p_ap_invoice_lines_all_rec.DISTRIBUTION_SET_ID
2320: ,p_ap_invoice_lines_all_rec.ACCOUNT_SEGMENT

Line 2317: ,p_ap_invoice_lines_all_rec.GENERATE_DISTS

2313: ,p_ap_invoice_lines_all_rec.SERIAL_NUMBER
2314: ,p_ap_invoice_lines_all_rec.MANUFACTURER
2315: ,p_ap_invoice_lines_all_rec.MODEL_NUMBER
2316: ,p_ap_invoice_lines_all_rec.WARRANTY_NUMBER
2317: ,p_ap_invoice_lines_all_rec.GENERATE_DISTS
2318: ,p_ap_invoice_lines_all_rec.MATCH_TYPE
2319: ,p_ap_invoice_lines_all_rec.DISTRIBUTION_SET_ID
2320: ,p_ap_invoice_lines_all_rec.ACCOUNT_SEGMENT
2321: ,p_ap_invoice_lines_all_rec.BALANCING_SEGMENT

Line 2318: ,p_ap_invoice_lines_all_rec.MATCH_TYPE

2314: ,p_ap_invoice_lines_all_rec.MANUFACTURER
2315: ,p_ap_invoice_lines_all_rec.MODEL_NUMBER
2316: ,p_ap_invoice_lines_all_rec.WARRANTY_NUMBER
2317: ,p_ap_invoice_lines_all_rec.GENERATE_DISTS
2318: ,p_ap_invoice_lines_all_rec.MATCH_TYPE
2319: ,p_ap_invoice_lines_all_rec.DISTRIBUTION_SET_ID
2320: ,p_ap_invoice_lines_all_rec.ACCOUNT_SEGMENT
2321: ,p_ap_invoice_lines_all_rec.BALANCING_SEGMENT
2322: ,p_ap_invoice_lines_all_rec.COST_CENTER_SEGMENT

Line 2319: ,p_ap_invoice_lines_all_rec.DISTRIBUTION_SET_ID

2315: ,p_ap_invoice_lines_all_rec.MODEL_NUMBER
2316: ,p_ap_invoice_lines_all_rec.WARRANTY_NUMBER
2317: ,p_ap_invoice_lines_all_rec.GENERATE_DISTS
2318: ,p_ap_invoice_lines_all_rec.MATCH_TYPE
2319: ,p_ap_invoice_lines_all_rec.DISTRIBUTION_SET_ID
2320: ,p_ap_invoice_lines_all_rec.ACCOUNT_SEGMENT
2321: ,p_ap_invoice_lines_all_rec.BALANCING_SEGMENT
2322: ,p_ap_invoice_lines_all_rec.COST_CENTER_SEGMENT
2323: ,p_ap_invoice_lines_all_rec.OVERLAY_DIST_CODE_CONCAT

Line 2320: ,p_ap_invoice_lines_all_rec.ACCOUNT_SEGMENT

2316: ,p_ap_invoice_lines_all_rec.WARRANTY_NUMBER
2317: ,p_ap_invoice_lines_all_rec.GENERATE_DISTS
2318: ,p_ap_invoice_lines_all_rec.MATCH_TYPE
2319: ,p_ap_invoice_lines_all_rec.DISTRIBUTION_SET_ID
2320: ,p_ap_invoice_lines_all_rec.ACCOUNT_SEGMENT
2321: ,p_ap_invoice_lines_all_rec.BALANCING_SEGMENT
2322: ,p_ap_invoice_lines_all_rec.COST_CENTER_SEGMENT
2323: ,p_ap_invoice_lines_all_rec.OVERLAY_DIST_CODE_CONCAT
2324: ,p_ap_invoice_lines_all_rec.DEFAULT_DIST_CCID

Line 2321: ,p_ap_invoice_lines_all_rec.BALANCING_SEGMENT

2317: ,p_ap_invoice_lines_all_rec.GENERATE_DISTS
2318: ,p_ap_invoice_lines_all_rec.MATCH_TYPE
2319: ,p_ap_invoice_lines_all_rec.DISTRIBUTION_SET_ID
2320: ,p_ap_invoice_lines_all_rec.ACCOUNT_SEGMENT
2321: ,p_ap_invoice_lines_all_rec.BALANCING_SEGMENT
2322: ,p_ap_invoice_lines_all_rec.COST_CENTER_SEGMENT
2323: ,p_ap_invoice_lines_all_rec.OVERLAY_DIST_CODE_CONCAT
2324: ,p_ap_invoice_lines_all_rec.DEFAULT_DIST_CCID
2325: ,p_ap_invoice_lines_all_rec.PRORATE_ACROSS_ALL_ITEMS

Line 2322: ,p_ap_invoice_lines_all_rec.COST_CENTER_SEGMENT

2318: ,p_ap_invoice_lines_all_rec.MATCH_TYPE
2319: ,p_ap_invoice_lines_all_rec.DISTRIBUTION_SET_ID
2320: ,p_ap_invoice_lines_all_rec.ACCOUNT_SEGMENT
2321: ,p_ap_invoice_lines_all_rec.BALANCING_SEGMENT
2322: ,p_ap_invoice_lines_all_rec.COST_CENTER_SEGMENT
2323: ,p_ap_invoice_lines_all_rec.OVERLAY_DIST_CODE_CONCAT
2324: ,p_ap_invoice_lines_all_rec.DEFAULT_DIST_CCID
2325: ,p_ap_invoice_lines_all_rec.PRORATE_ACROSS_ALL_ITEMS
2326: ,p_ap_invoice_lines_all_rec.ACCOUNTING_DATE

Line 2323: ,p_ap_invoice_lines_all_rec.OVERLAY_DIST_CODE_CONCAT

2319: ,p_ap_invoice_lines_all_rec.DISTRIBUTION_SET_ID
2320: ,p_ap_invoice_lines_all_rec.ACCOUNT_SEGMENT
2321: ,p_ap_invoice_lines_all_rec.BALANCING_SEGMENT
2322: ,p_ap_invoice_lines_all_rec.COST_CENTER_SEGMENT
2323: ,p_ap_invoice_lines_all_rec.OVERLAY_DIST_CODE_CONCAT
2324: ,p_ap_invoice_lines_all_rec.DEFAULT_DIST_CCID
2325: ,p_ap_invoice_lines_all_rec.PRORATE_ACROSS_ALL_ITEMS
2326: ,p_ap_invoice_lines_all_rec.ACCOUNTING_DATE
2327: ,p_ap_invoice_lines_all_rec.PERIOD_NAME

Line 2324: ,p_ap_invoice_lines_all_rec.DEFAULT_DIST_CCID

2320: ,p_ap_invoice_lines_all_rec.ACCOUNT_SEGMENT
2321: ,p_ap_invoice_lines_all_rec.BALANCING_SEGMENT
2322: ,p_ap_invoice_lines_all_rec.COST_CENTER_SEGMENT
2323: ,p_ap_invoice_lines_all_rec.OVERLAY_DIST_CODE_CONCAT
2324: ,p_ap_invoice_lines_all_rec.DEFAULT_DIST_CCID
2325: ,p_ap_invoice_lines_all_rec.PRORATE_ACROSS_ALL_ITEMS
2326: ,p_ap_invoice_lines_all_rec.ACCOUNTING_DATE
2327: ,p_ap_invoice_lines_all_rec.PERIOD_NAME
2328: ,p_ap_invoice_lines_all_rec.DEFERRED_ACCTG_FLAG

Line 2325: ,p_ap_invoice_lines_all_rec.PRORATE_ACROSS_ALL_ITEMS

2321: ,p_ap_invoice_lines_all_rec.BALANCING_SEGMENT
2322: ,p_ap_invoice_lines_all_rec.COST_CENTER_SEGMENT
2323: ,p_ap_invoice_lines_all_rec.OVERLAY_DIST_CODE_CONCAT
2324: ,p_ap_invoice_lines_all_rec.DEFAULT_DIST_CCID
2325: ,p_ap_invoice_lines_all_rec.PRORATE_ACROSS_ALL_ITEMS
2326: ,p_ap_invoice_lines_all_rec.ACCOUNTING_DATE
2327: ,p_ap_invoice_lines_all_rec.PERIOD_NAME
2328: ,p_ap_invoice_lines_all_rec.DEFERRED_ACCTG_FLAG
2329: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_START_DATE

Line 2326: ,p_ap_invoice_lines_all_rec.ACCOUNTING_DATE

2322: ,p_ap_invoice_lines_all_rec.COST_CENTER_SEGMENT
2323: ,p_ap_invoice_lines_all_rec.OVERLAY_DIST_CODE_CONCAT
2324: ,p_ap_invoice_lines_all_rec.DEFAULT_DIST_CCID
2325: ,p_ap_invoice_lines_all_rec.PRORATE_ACROSS_ALL_ITEMS
2326: ,p_ap_invoice_lines_all_rec.ACCOUNTING_DATE
2327: ,p_ap_invoice_lines_all_rec.PERIOD_NAME
2328: ,p_ap_invoice_lines_all_rec.DEFERRED_ACCTG_FLAG
2329: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_START_DATE
2330: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_END_DATE

Line 2327: ,p_ap_invoice_lines_all_rec.PERIOD_NAME

2323: ,p_ap_invoice_lines_all_rec.OVERLAY_DIST_CODE_CONCAT
2324: ,p_ap_invoice_lines_all_rec.DEFAULT_DIST_CCID
2325: ,p_ap_invoice_lines_all_rec.PRORATE_ACROSS_ALL_ITEMS
2326: ,p_ap_invoice_lines_all_rec.ACCOUNTING_DATE
2327: ,p_ap_invoice_lines_all_rec.PERIOD_NAME
2328: ,p_ap_invoice_lines_all_rec.DEFERRED_ACCTG_FLAG
2329: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_START_DATE
2330: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_END_DATE
2331: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_NUMBER_OF_PERIODS

Line 2328: ,p_ap_invoice_lines_all_rec.DEFERRED_ACCTG_FLAG

2324: ,p_ap_invoice_lines_all_rec.DEFAULT_DIST_CCID
2325: ,p_ap_invoice_lines_all_rec.PRORATE_ACROSS_ALL_ITEMS
2326: ,p_ap_invoice_lines_all_rec.ACCOUNTING_DATE
2327: ,p_ap_invoice_lines_all_rec.PERIOD_NAME
2328: ,p_ap_invoice_lines_all_rec.DEFERRED_ACCTG_FLAG
2329: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_START_DATE
2330: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_END_DATE
2331: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_NUMBER_OF_PERIODS
2332: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_PERIOD_TYPE

Line 2329: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_START_DATE

2325: ,p_ap_invoice_lines_all_rec.PRORATE_ACROSS_ALL_ITEMS
2326: ,p_ap_invoice_lines_all_rec.ACCOUNTING_DATE
2327: ,p_ap_invoice_lines_all_rec.PERIOD_NAME
2328: ,p_ap_invoice_lines_all_rec.DEFERRED_ACCTG_FLAG
2329: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_START_DATE
2330: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_END_DATE
2331: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_NUMBER_OF_PERIODS
2332: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_PERIOD_TYPE
2333: ,p_ap_invoice_lines_all_rec.SET_OF_BOOKS_ID

Line 2330: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_END_DATE

2326: ,p_ap_invoice_lines_all_rec.ACCOUNTING_DATE
2327: ,p_ap_invoice_lines_all_rec.PERIOD_NAME
2328: ,p_ap_invoice_lines_all_rec.DEFERRED_ACCTG_FLAG
2329: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_START_DATE
2330: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_END_DATE
2331: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_NUMBER_OF_PERIODS
2332: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_PERIOD_TYPE
2333: ,p_ap_invoice_lines_all_rec.SET_OF_BOOKS_ID
2334: ,p_ap_invoice_lines_all_rec.AMOUNT

Line 2331: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_NUMBER_OF_PERIODS

2327: ,p_ap_invoice_lines_all_rec.PERIOD_NAME
2328: ,p_ap_invoice_lines_all_rec.DEFERRED_ACCTG_FLAG
2329: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_START_DATE
2330: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_END_DATE
2331: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_NUMBER_OF_PERIODS
2332: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_PERIOD_TYPE
2333: ,p_ap_invoice_lines_all_rec.SET_OF_BOOKS_ID
2334: ,p_ap_invoice_lines_all_rec.AMOUNT
2335: ,p_ap_invoice_lines_all_rec.BASE_AMOUNT

Line 2332: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_PERIOD_TYPE

2328: ,p_ap_invoice_lines_all_rec.DEFERRED_ACCTG_FLAG
2329: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_START_DATE
2330: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_END_DATE
2331: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_NUMBER_OF_PERIODS
2332: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_PERIOD_TYPE
2333: ,p_ap_invoice_lines_all_rec.SET_OF_BOOKS_ID
2334: ,p_ap_invoice_lines_all_rec.AMOUNT
2335: ,p_ap_invoice_lines_all_rec.BASE_AMOUNT
2336: ,p_ap_invoice_lines_all_rec.ROUNDING_AMT

Line 2333: ,p_ap_invoice_lines_all_rec.SET_OF_BOOKS_ID

2329: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_START_DATE
2330: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_END_DATE
2331: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_NUMBER_OF_PERIODS
2332: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_PERIOD_TYPE
2333: ,p_ap_invoice_lines_all_rec.SET_OF_BOOKS_ID
2334: ,p_ap_invoice_lines_all_rec.AMOUNT
2335: ,p_ap_invoice_lines_all_rec.BASE_AMOUNT
2336: ,p_ap_invoice_lines_all_rec.ROUNDING_AMT
2337: ,p_ap_invoice_lines_all_rec.QUANTITY_INVOICED

Line 2334: ,p_ap_invoice_lines_all_rec.AMOUNT

2330: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_END_DATE
2331: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_NUMBER_OF_PERIODS
2332: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_PERIOD_TYPE
2333: ,p_ap_invoice_lines_all_rec.SET_OF_BOOKS_ID
2334: ,p_ap_invoice_lines_all_rec.AMOUNT
2335: ,p_ap_invoice_lines_all_rec.BASE_AMOUNT
2336: ,p_ap_invoice_lines_all_rec.ROUNDING_AMT
2337: ,p_ap_invoice_lines_all_rec.QUANTITY_INVOICED
2338: ,p_ap_invoice_lines_all_rec.UNIT_MEAS_LOOKUP_CODE

Line 2335: ,p_ap_invoice_lines_all_rec.BASE_AMOUNT

2331: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_NUMBER_OF_PERIODS
2332: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_PERIOD_TYPE
2333: ,p_ap_invoice_lines_all_rec.SET_OF_BOOKS_ID
2334: ,p_ap_invoice_lines_all_rec.AMOUNT
2335: ,p_ap_invoice_lines_all_rec.BASE_AMOUNT
2336: ,p_ap_invoice_lines_all_rec.ROUNDING_AMT
2337: ,p_ap_invoice_lines_all_rec.QUANTITY_INVOICED
2338: ,p_ap_invoice_lines_all_rec.UNIT_MEAS_LOOKUP_CODE
2339: ,p_ap_invoice_lines_all_rec.UNIT_PRICE

Line 2336: ,p_ap_invoice_lines_all_rec.ROUNDING_AMT

2332: ,p_ap_invoice_lines_all_rec.DEF_ACCTG_PERIOD_TYPE
2333: ,p_ap_invoice_lines_all_rec.SET_OF_BOOKS_ID
2334: ,p_ap_invoice_lines_all_rec.AMOUNT
2335: ,p_ap_invoice_lines_all_rec.BASE_AMOUNT
2336: ,p_ap_invoice_lines_all_rec.ROUNDING_AMT
2337: ,p_ap_invoice_lines_all_rec.QUANTITY_INVOICED
2338: ,p_ap_invoice_lines_all_rec.UNIT_MEAS_LOOKUP_CODE
2339: ,p_ap_invoice_lines_all_rec.UNIT_PRICE
2340: ,p_ap_invoice_lines_all_rec.WFAPPROVAL_STATUS

Line 2337: ,p_ap_invoice_lines_all_rec.QUANTITY_INVOICED

2333: ,p_ap_invoice_lines_all_rec.SET_OF_BOOKS_ID
2334: ,p_ap_invoice_lines_all_rec.AMOUNT
2335: ,p_ap_invoice_lines_all_rec.BASE_AMOUNT
2336: ,p_ap_invoice_lines_all_rec.ROUNDING_AMT
2337: ,p_ap_invoice_lines_all_rec.QUANTITY_INVOICED
2338: ,p_ap_invoice_lines_all_rec.UNIT_MEAS_LOOKUP_CODE
2339: ,p_ap_invoice_lines_all_rec.UNIT_PRICE
2340: ,p_ap_invoice_lines_all_rec.WFAPPROVAL_STATUS
2341: ,p_ap_invoice_lines_all_rec.USSGL_TRANSACTION_CODE

Line 2338: ,p_ap_invoice_lines_all_rec.UNIT_MEAS_LOOKUP_CODE

2334: ,p_ap_invoice_lines_all_rec.AMOUNT
2335: ,p_ap_invoice_lines_all_rec.BASE_AMOUNT
2336: ,p_ap_invoice_lines_all_rec.ROUNDING_AMT
2337: ,p_ap_invoice_lines_all_rec.QUANTITY_INVOICED
2338: ,p_ap_invoice_lines_all_rec.UNIT_MEAS_LOOKUP_CODE
2339: ,p_ap_invoice_lines_all_rec.UNIT_PRICE
2340: ,p_ap_invoice_lines_all_rec.WFAPPROVAL_STATUS
2341: ,p_ap_invoice_lines_all_rec.USSGL_TRANSACTION_CODE
2342: ,p_ap_invoice_lines_all_rec.DISCARDED_FLAG

Line 2339: ,p_ap_invoice_lines_all_rec.UNIT_PRICE

2335: ,p_ap_invoice_lines_all_rec.BASE_AMOUNT
2336: ,p_ap_invoice_lines_all_rec.ROUNDING_AMT
2337: ,p_ap_invoice_lines_all_rec.QUANTITY_INVOICED
2338: ,p_ap_invoice_lines_all_rec.UNIT_MEAS_LOOKUP_CODE
2339: ,p_ap_invoice_lines_all_rec.UNIT_PRICE
2340: ,p_ap_invoice_lines_all_rec.WFAPPROVAL_STATUS
2341: ,p_ap_invoice_lines_all_rec.USSGL_TRANSACTION_CODE
2342: ,p_ap_invoice_lines_all_rec.DISCARDED_FLAG
2343: ,p_ap_invoice_lines_all_rec.ORIGINAL_AMOUNT

Line 2340: ,p_ap_invoice_lines_all_rec.WFAPPROVAL_STATUS

2336: ,p_ap_invoice_lines_all_rec.ROUNDING_AMT
2337: ,p_ap_invoice_lines_all_rec.QUANTITY_INVOICED
2338: ,p_ap_invoice_lines_all_rec.UNIT_MEAS_LOOKUP_CODE
2339: ,p_ap_invoice_lines_all_rec.UNIT_PRICE
2340: ,p_ap_invoice_lines_all_rec.WFAPPROVAL_STATUS
2341: ,p_ap_invoice_lines_all_rec.USSGL_TRANSACTION_CODE
2342: ,p_ap_invoice_lines_all_rec.DISCARDED_FLAG
2343: ,p_ap_invoice_lines_all_rec.ORIGINAL_AMOUNT
2344: ,p_ap_invoice_lines_all_rec.ORIGINAL_BASE_AMOUNT

Line 2341: ,p_ap_invoice_lines_all_rec.USSGL_TRANSACTION_CODE

2337: ,p_ap_invoice_lines_all_rec.QUANTITY_INVOICED
2338: ,p_ap_invoice_lines_all_rec.UNIT_MEAS_LOOKUP_CODE
2339: ,p_ap_invoice_lines_all_rec.UNIT_PRICE
2340: ,p_ap_invoice_lines_all_rec.WFAPPROVAL_STATUS
2341: ,p_ap_invoice_lines_all_rec.USSGL_TRANSACTION_CODE
2342: ,p_ap_invoice_lines_all_rec.DISCARDED_FLAG
2343: ,p_ap_invoice_lines_all_rec.ORIGINAL_AMOUNT
2344: ,p_ap_invoice_lines_all_rec.ORIGINAL_BASE_AMOUNT
2345: ,p_ap_invoice_lines_all_rec.ORIGINAL_ROUNDING_AMT

Line 2342: ,p_ap_invoice_lines_all_rec.DISCARDED_FLAG

2338: ,p_ap_invoice_lines_all_rec.UNIT_MEAS_LOOKUP_CODE
2339: ,p_ap_invoice_lines_all_rec.UNIT_PRICE
2340: ,p_ap_invoice_lines_all_rec.WFAPPROVAL_STATUS
2341: ,p_ap_invoice_lines_all_rec.USSGL_TRANSACTION_CODE
2342: ,p_ap_invoice_lines_all_rec.DISCARDED_FLAG
2343: ,p_ap_invoice_lines_all_rec.ORIGINAL_AMOUNT
2344: ,p_ap_invoice_lines_all_rec.ORIGINAL_BASE_AMOUNT
2345: ,p_ap_invoice_lines_all_rec.ORIGINAL_ROUNDING_AMT
2346: ,p_ap_invoice_lines_all_rec.CANCELLED_FLAG

Line 2343: ,p_ap_invoice_lines_all_rec.ORIGINAL_AMOUNT

2339: ,p_ap_invoice_lines_all_rec.UNIT_PRICE
2340: ,p_ap_invoice_lines_all_rec.WFAPPROVAL_STATUS
2341: ,p_ap_invoice_lines_all_rec.USSGL_TRANSACTION_CODE
2342: ,p_ap_invoice_lines_all_rec.DISCARDED_FLAG
2343: ,p_ap_invoice_lines_all_rec.ORIGINAL_AMOUNT
2344: ,p_ap_invoice_lines_all_rec.ORIGINAL_BASE_AMOUNT
2345: ,p_ap_invoice_lines_all_rec.ORIGINAL_ROUNDING_AMT
2346: ,p_ap_invoice_lines_all_rec.CANCELLED_FLAG
2347: ,p_ap_invoice_lines_all_rec.INCOME_TAX_REGION

Line 2344: ,p_ap_invoice_lines_all_rec.ORIGINAL_BASE_AMOUNT

2340: ,p_ap_invoice_lines_all_rec.WFAPPROVAL_STATUS
2341: ,p_ap_invoice_lines_all_rec.USSGL_TRANSACTION_CODE
2342: ,p_ap_invoice_lines_all_rec.DISCARDED_FLAG
2343: ,p_ap_invoice_lines_all_rec.ORIGINAL_AMOUNT
2344: ,p_ap_invoice_lines_all_rec.ORIGINAL_BASE_AMOUNT
2345: ,p_ap_invoice_lines_all_rec.ORIGINAL_ROUNDING_AMT
2346: ,p_ap_invoice_lines_all_rec.CANCELLED_FLAG
2347: ,p_ap_invoice_lines_all_rec.INCOME_TAX_REGION
2348: ,p_ap_invoice_lines_all_rec.TYPE_1099

Line 2345: ,p_ap_invoice_lines_all_rec.ORIGINAL_ROUNDING_AMT

2341: ,p_ap_invoice_lines_all_rec.USSGL_TRANSACTION_CODE
2342: ,p_ap_invoice_lines_all_rec.DISCARDED_FLAG
2343: ,p_ap_invoice_lines_all_rec.ORIGINAL_AMOUNT
2344: ,p_ap_invoice_lines_all_rec.ORIGINAL_BASE_AMOUNT
2345: ,p_ap_invoice_lines_all_rec.ORIGINAL_ROUNDING_AMT
2346: ,p_ap_invoice_lines_all_rec.CANCELLED_FLAG
2347: ,p_ap_invoice_lines_all_rec.INCOME_TAX_REGION
2348: ,p_ap_invoice_lines_all_rec.TYPE_1099
2349: ,p_ap_invoice_lines_all_rec.STAT_AMOUNT

Line 2346: ,p_ap_invoice_lines_all_rec.CANCELLED_FLAG

2342: ,p_ap_invoice_lines_all_rec.DISCARDED_FLAG
2343: ,p_ap_invoice_lines_all_rec.ORIGINAL_AMOUNT
2344: ,p_ap_invoice_lines_all_rec.ORIGINAL_BASE_AMOUNT
2345: ,p_ap_invoice_lines_all_rec.ORIGINAL_ROUNDING_AMT
2346: ,p_ap_invoice_lines_all_rec.CANCELLED_FLAG
2347: ,p_ap_invoice_lines_all_rec.INCOME_TAX_REGION
2348: ,p_ap_invoice_lines_all_rec.TYPE_1099
2349: ,p_ap_invoice_lines_all_rec.STAT_AMOUNT
2350: ,p_ap_invoice_lines_all_rec.PREPAY_INVOICE_ID

Line 2347: ,p_ap_invoice_lines_all_rec.INCOME_TAX_REGION

2343: ,p_ap_invoice_lines_all_rec.ORIGINAL_AMOUNT
2344: ,p_ap_invoice_lines_all_rec.ORIGINAL_BASE_AMOUNT
2345: ,p_ap_invoice_lines_all_rec.ORIGINAL_ROUNDING_AMT
2346: ,p_ap_invoice_lines_all_rec.CANCELLED_FLAG
2347: ,p_ap_invoice_lines_all_rec.INCOME_TAX_REGION
2348: ,p_ap_invoice_lines_all_rec.TYPE_1099
2349: ,p_ap_invoice_lines_all_rec.STAT_AMOUNT
2350: ,p_ap_invoice_lines_all_rec.PREPAY_INVOICE_ID
2351: ,p_ap_invoice_lines_all_rec.PREPAY_LINE_NUMBER

Line 2348: ,p_ap_invoice_lines_all_rec.TYPE_1099

2344: ,p_ap_invoice_lines_all_rec.ORIGINAL_BASE_AMOUNT
2345: ,p_ap_invoice_lines_all_rec.ORIGINAL_ROUNDING_AMT
2346: ,p_ap_invoice_lines_all_rec.CANCELLED_FLAG
2347: ,p_ap_invoice_lines_all_rec.INCOME_TAX_REGION
2348: ,p_ap_invoice_lines_all_rec.TYPE_1099
2349: ,p_ap_invoice_lines_all_rec.STAT_AMOUNT
2350: ,p_ap_invoice_lines_all_rec.PREPAY_INVOICE_ID
2351: ,p_ap_invoice_lines_all_rec.PREPAY_LINE_NUMBER
2352: ,p_ap_invoice_lines_all_rec.INVOICE_INCLUDES_PREPAY_FLAG

Line 2349: ,p_ap_invoice_lines_all_rec.STAT_AMOUNT

2345: ,p_ap_invoice_lines_all_rec.ORIGINAL_ROUNDING_AMT
2346: ,p_ap_invoice_lines_all_rec.CANCELLED_FLAG
2347: ,p_ap_invoice_lines_all_rec.INCOME_TAX_REGION
2348: ,p_ap_invoice_lines_all_rec.TYPE_1099
2349: ,p_ap_invoice_lines_all_rec.STAT_AMOUNT
2350: ,p_ap_invoice_lines_all_rec.PREPAY_INVOICE_ID
2351: ,p_ap_invoice_lines_all_rec.PREPAY_LINE_NUMBER
2352: ,p_ap_invoice_lines_all_rec.INVOICE_INCLUDES_PREPAY_FLAG
2353: ,p_ap_invoice_lines_all_rec.CORRECTED_INV_ID

Line 2350: ,p_ap_invoice_lines_all_rec.PREPAY_INVOICE_ID

2346: ,p_ap_invoice_lines_all_rec.CANCELLED_FLAG
2347: ,p_ap_invoice_lines_all_rec.INCOME_TAX_REGION
2348: ,p_ap_invoice_lines_all_rec.TYPE_1099
2349: ,p_ap_invoice_lines_all_rec.STAT_AMOUNT
2350: ,p_ap_invoice_lines_all_rec.PREPAY_INVOICE_ID
2351: ,p_ap_invoice_lines_all_rec.PREPAY_LINE_NUMBER
2352: ,p_ap_invoice_lines_all_rec.INVOICE_INCLUDES_PREPAY_FLAG
2353: ,p_ap_invoice_lines_all_rec.CORRECTED_INV_ID
2354: ,p_ap_invoice_lines_all_rec.CORRECTED_LINE_NUMBER

Line 2351: ,p_ap_invoice_lines_all_rec.PREPAY_LINE_NUMBER

2347: ,p_ap_invoice_lines_all_rec.INCOME_TAX_REGION
2348: ,p_ap_invoice_lines_all_rec.TYPE_1099
2349: ,p_ap_invoice_lines_all_rec.STAT_AMOUNT
2350: ,p_ap_invoice_lines_all_rec.PREPAY_INVOICE_ID
2351: ,p_ap_invoice_lines_all_rec.PREPAY_LINE_NUMBER
2352: ,p_ap_invoice_lines_all_rec.INVOICE_INCLUDES_PREPAY_FLAG
2353: ,p_ap_invoice_lines_all_rec.CORRECTED_INV_ID
2354: ,p_ap_invoice_lines_all_rec.CORRECTED_LINE_NUMBER
2355: ,p_ap_invoice_lines_all_rec.PO_HEADER_ID

Line 2352: ,p_ap_invoice_lines_all_rec.INVOICE_INCLUDES_PREPAY_FLAG

2348: ,p_ap_invoice_lines_all_rec.TYPE_1099
2349: ,p_ap_invoice_lines_all_rec.STAT_AMOUNT
2350: ,p_ap_invoice_lines_all_rec.PREPAY_INVOICE_ID
2351: ,p_ap_invoice_lines_all_rec.PREPAY_LINE_NUMBER
2352: ,p_ap_invoice_lines_all_rec.INVOICE_INCLUDES_PREPAY_FLAG
2353: ,p_ap_invoice_lines_all_rec.CORRECTED_INV_ID
2354: ,p_ap_invoice_lines_all_rec.CORRECTED_LINE_NUMBER
2355: ,p_ap_invoice_lines_all_rec.PO_HEADER_ID
2356: ,p_ap_invoice_lines_all_rec.PO_LINE_ID

Line 2353: ,p_ap_invoice_lines_all_rec.CORRECTED_INV_ID

2349: ,p_ap_invoice_lines_all_rec.STAT_AMOUNT
2350: ,p_ap_invoice_lines_all_rec.PREPAY_INVOICE_ID
2351: ,p_ap_invoice_lines_all_rec.PREPAY_LINE_NUMBER
2352: ,p_ap_invoice_lines_all_rec.INVOICE_INCLUDES_PREPAY_FLAG
2353: ,p_ap_invoice_lines_all_rec.CORRECTED_INV_ID
2354: ,p_ap_invoice_lines_all_rec.CORRECTED_LINE_NUMBER
2355: ,p_ap_invoice_lines_all_rec.PO_HEADER_ID
2356: ,p_ap_invoice_lines_all_rec.PO_LINE_ID
2357: ,p_ap_invoice_lines_all_rec.PO_RELEASE_ID

Line 2354: ,p_ap_invoice_lines_all_rec.CORRECTED_LINE_NUMBER

2350: ,p_ap_invoice_lines_all_rec.PREPAY_INVOICE_ID
2351: ,p_ap_invoice_lines_all_rec.PREPAY_LINE_NUMBER
2352: ,p_ap_invoice_lines_all_rec.INVOICE_INCLUDES_PREPAY_FLAG
2353: ,p_ap_invoice_lines_all_rec.CORRECTED_INV_ID
2354: ,p_ap_invoice_lines_all_rec.CORRECTED_LINE_NUMBER
2355: ,p_ap_invoice_lines_all_rec.PO_HEADER_ID
2356: ,p_ap_invoice_lines_all_rec.PO_LINE_ID
2357: ,p_ap_invoice_lines_all_rec.PO_RELEASE_ID
2358: ,p_ap_invoice_lines_all_rec.PO_LINE_LOCATION_ID

Line 2355: ,p_ap_invoice_lines_all_rec.PO_HEADER_ID

2351: ,p_ap_invoice_lines_all_rec.PREPAY_LINE_NUMBER
2352: ,p_ap_invoice_lines_all_rec.INVOICE_INCLUDES_PREPAY_FLAG
2353: ,p_ap_invoice_lines_all_rec.CORRECTED_INV_ID
2354: ,p_ap_invoice_lines_all_rec.CORRECTED_LINE_NUMBER
2355: ,p_ap_invoice_lines_all_rec.PO_HEADER_ID
2356: ,p_ap_invoice_lines_all_rec.PO_LINE_ID
2357: ,p_ap_invoice_lines_all_rec.PO_RELEASE_ID
2358: ,p_ap_invoice_lines_all_rec.PO_LINE_LOCATION_ID
2359: ,p_ap_invoice_lines_all_rec.PO_DISTRIBUTION_ID

Line 2356: ,p_ap_invoice_lines_all_rec.PO_LINE_ID

2352: ,p_ap_invoice_lines_all_rec.INVOICE_INCLUDES_PREPAY_FLAG
2353: ,p_ap_invoice_lines_all_rec.CORRECTED_INV_ID
2354: ,p_ap_invoice_lines_all_rec.CORRECTED_LINE_NUMBER
2355: ,p_ap_invoice_lines_all_rec.PO_HEADER_ID
2356: ,p_ap_invoice_lines_all_rec.PO_LINE_ID
2357: ,p_ap_invoice_lines_all_rec.PO_RELEASE_ID
2358: ,p_ap_invoice_lines_all_rec.PO_LINE_LOCATION_ID
2359: ,p_ap_invoice_lines_all_rec.PO_DISTRIBUTION_ID
2360: ,p_ap_invoice_lines_all_rec.RCV_TRANSACTION_ID

Line 2357: ,p_ap_invoice_lines_all_rec.PO_RELEASE_ID

2353: ,p_ap_invoice_lines_all_rec.CORRECTED_INV_ID
2354: ,p_ap_invoice_lines_all_rec.CORRECTED_LINE_NUMBER
2355: ,p_ap_invoice_lines_all_rec.PO_HEADER_ID
2356: ,p_ap_invoice_lines_all_rec.PO_LINE_ID
2357: ,p_ap_invoice_lines_all_rec.PO_RELEASE_ID
2358: ,p_ap_invoice_lines_all_rec.PO_LINE_LOCATION_ID
2359: ,p_ap_invoice_lines_all_rec.PO_DISTRIBUTION_ID
2360: ,p_ap_invoice_lines_all_rec.RCV_TRANSACTION_ID
2361: ,p_ap_invoice_lines_all_rec.FINAL_MATCH_FLAG

Line 2358: ,p_ap_invoice_lines_all_rec.PO_LINE_LOCATION_ID

2354: ,p_ap_invoice_lines_all_rec.CORRECTED_LINE_NUMBER
2355: ,p_ap_invoice_lines_all_rec.PO_HEADER_ID
2356: ,p_ap_invoice_lines_all_rec.PO_LINE_ID
2357: ,p_ap_invoice_lines_all_rec.PO_RELEASE_ID
2358: ,p_ap_invoice_lines_all_rec.PO_LINE_LOCATION_ID
2359: ,p_ap_invoice_lines_all_rec.PO_DISTRIBUTION_ID
2360: ,p_ap_invoice_lines_all_rec.RCV_TRANSACTION_ID
2361: ,p_ap_invoice_lines_all_rec.FINAL_MATCH_FLAG
2362: ,p_ap_invoice_lines_all_rec.ASSETS_TRACKING_FLAG

Line 2359: ,p_ap_invoice_lines_all_rec.PO_DISTRIBUTION_ID

2355: ,p_ap_invoice_lines_all_rec.PO_HEADER_ID
2356: ,p_ap_invoice_lines_all_rec.PO_LINE_ID
2357: ,p_ap_invoice_lines_all_rec.PO_RELEASE_ID
2358: ,p_ap_invoice_lines_all_rec.PO_LINE_LOCATION_ID
2359: ,p_ap_invoice_lines_all_rec.PO_DISTRIBUTION_ID
2360: ,p_ap_invoice_lines_all_rec.RCV_TRANSACTION_ID
2361: ,p_ap_invoice_lines_all_rec.FINAL_MATCH_FLAG
2362: ,p_ap_invoice_lines_all_rec.ASSETS_TRACKING_FLAG
2363: ,p_ap_invoice_lines_all_rec.ASSET_BOOK_TYPE_CODE

Line 2360: ,p_ap_invoice_lines_all_rec.RCV_TRANSACTION_ID

2356: ,p_ap_invoice_lines_all_rec.PO_LINE_ID
2357: ,p_ap_invoice_lines_all_rec.PO_RELEASE_ID
2358: ,p_ap_invoice_lines_all_rec.PO_LINE_LOCATION_ID
2359: ,p_ap_invoice_lines_all_rec.PO_DISTRIBUTION_ID
2360: ,p_ap_invoice_lines_all_rec.RCV_TRANSACTION_ID
2361: ,p_ap_invoice_lines_all_rec.FINAL_MATCH_FLAG
2362: ,p_ap_invoice_lines_all_rec.ASSETS_TRACKING_FLAG
2363: ,p_ap_invoice_lines_all_rec.ASSET_BOOK_TYPE_CODE
2364: ,p_ap_invoice_lines_all_rec.ASSET_CATEGORY_ID

Line 2361: ,p_ap_invoice_lines_all_rec.FINAL_MATCH_FLAG

2357: ,p_ap_invoice_lines_all_rec.PO_RELEASE_ID
2358: ,p_ap_invoice_lines_all_rec.PO_LINE_LOCATION_ID
2359: ,p_ap_invoice_lines_all_rec.PO_DISTRIBUTION_ID
2360: ,p_ap_invoice_lines_all_rec.RCV_TRANSACTION_ID
2361: ,p_ap_invoice_lines_all_rec.FINAL_MATCH_FLAG
2362: ,p_ap_invoice_lines_all_rec.ASSETS_TRACKING_FLAG
2363: ,p_ap_invoice_lines_all_rec.ASSET_BOOK_TYPE_CODE
2364: ,p_ap_invoice_lines_all_rec.ASSET_CATEGORY_ID
2365: ,p_ap_invoice_lines_all_rec.PROJECT_ID

Line 2362: ,p_ap_invoice_lines_all_rec.ASSETS_TRACKING_FLAG

2358: ,p_ap_invoice_lines_all_rec.PO_LINE_LOCATION_ID
2359: ,p_ap_invoice_lines_all_rec.PO_DISTRIBUTION_ID
2360: ,p_ap_invoice_lines_all_rec.RCV_TRANSACTION_ID
2361: ,p_ap_invoice_lines_all_rec.FINAL_MATCH_FLAG
2362: ,p_ap_invoice_lines_all_rec.ASSETS_TRACKING_FLAG
2363: ,p_ap_invoice_lines_all_rec.ASSET_BOOK_TYPE_CODE
2364: ,p_ap_invoice_lines_all_rec.ASSET_CATEGORY_ID
2365: ,p_ap_invoice_lines_all_rec.PROJECT_ID
2366: ,p_ap_invoice_lines_all_rec.TASK_ID

Line 2363: ,p_ap_invoice_lines_all_rec.ASSET_BOOK_TYPE_CODE

2359: ,p_ap_invoice_lines_all_rec.PO_DISTRIBUTION_ID
2360: ,p_ap_invoice_lines_all_rec.RCV_TRANSACTION_ID
2361: ,p_ap_invoice_lines_all_rec.FINAL_MATCH_FLAG
2362: ,p_ap_invoice_lines_all_rec.ASSETS_TRACKING_FLAG
2363: ,p_ap_invoice_lines_all_rec.ASSET_BOOK_TYPE_CODE
2364: ,p_ap_invoice_lines_all_rec.ASSET_CATEGORY_ID
2365: ,p_ap_invoice_lines_all_rec.PROJECT_ID
2366: ,p_ap_invoice_lines_all_rec.TASK_ID
2367: ,p_ap_invoice_lines_all_rec.EXPENDITURE_TYPE

Line 2364: ,p_ap_invoice_lines_all_rec.ASSET_CATEGORY_ID

2360: ,p_ap_invoice_lines_all_rec.RCV_TRANSACTION_ID
2361: ,p_ap_invoice_lines_all_rec.FINAL_MATCH_FLAG
2362: ,p_ap_invoice_lines_all_rec.ASSETS_TRACKING_FLAG
2363: ,p_ap_invoice_lines_all_rec.ASSET_BOOK_TYPE_CODE
2364: ,p_ap_invoice_lines_all_rec.ASSET_CATEGORY_ID
2365: ,p_ap_invoice_lines_all_rec.PROJECT_ID
2366: ,p_ap_invoice_lines_all_rec.TASK_ID
2367: ,p_ap_invoice_lines_all_rec.EXPENDITURE_TYPE
2368: ,p_ap_invoice_lines_all_rec.EXPENDITURE_ITEM_DATE

Line 2365: ,p_ap_invoice_lines_all_rec.PROJECT_ID

2361: ,p_ap_invoice_lines_all_rec.FINAL_MATCH_FLAG
2362: ,p_ap_invoice_lines_all_rec.ASSETS_TRACKING_FLAG
2363: ,p_ap_invoice_lines_all_rec.ASSET_BOOK_TYPE_CODE
2364: ,p_ap_invoice_lines_all_rec.ASSET_CATEGORY_ID
2365: ,p_ap_invoice_lines_all_rec.PROJECT_ID
2366: ,p_ap_invoice_lines_all_rec.TASK_ID
2367: ,p_ap_invoice_lines_all_rec.EXPENDITURE_TYPE
2368: ,p_ap_invoice_lines_all_rec.EXPENDITURE_ITEM_DATE
2369: ,p_ap_invoice_lines_all_rec.EXPENDITURE_ORGANIZATION_ID

Line 2366: ,p_ap_invoice_lines_all_rec.TASK_ID

2362: ,p_ap_invoice_lines_all_rec.ASSETS_TRACKING_FLAG
2363: ,p_ap_invoice_lines_all_rec.ASSET_BOOK_TYPE_CODE
2364: ,p_ap_invoice_lines_all_rec.ASSET_CATEGORY_ID
2365: ,p_ap_invoice_lines_all_rec.PROJECT_ID
2366: ,p_ap_invoice_lines_all_rec.TASK_ID
2367: ,p_ap_invoice_lines_all_rec.EXPENDITURE_TYPE
2368: ,p_ap_invoice_lines_all_rec.EXPENDITURE_ITEM_DATE
2369: ,p_ap_invoice_lines_all_rec.EXPENDITURE_ORGANIZATION_ID
2370: ,p_ap_invoice_lines_all_rec.PA_QUANTITY

Line 2367: ,p_ap_invoice_lines_all_rec.EXPENDITURE_TYPE

2363: ,p_ap_invoice_lines_all_rec.ASSET_BOOK_TYPE_CODE
2364: ,p_ap_invoice_lines_all_rec.ASSET_CATEGORY_ID
2365: ,p_ap_invoice_lines_all_rec.PROJECT_ID
2366: ,p_ap_invoice_lines_all_rec.TASK_ID
2367: ,p_ap_invoice_lines_all_rec.EXPENDITURE_TYPE
2368: ,p_ap_invoice_lines_all_rec.EXPENDITURE_ITEM_DATE
2369: ,p_ap_invoice_lines_all_rec.EXPENDITURE_ORGANIZATION_ID
2370: ,p_ap_invoice_lines_all_rec.PA_QUANTITY
2371: ,p_ap_invoice_lines_all_rec.PA_CC_AR_INVOICE_ID

Line 2368: ,p_ap_invoice_lines_all_rec.EXPENDITURE_ITEM_DATE

2364: ,p_ap_invoice_lines_all_rec.ASSET_CATEGORY_ID
2365: ,p_ap_invoice_lines_all_rec.PROJECT_ID
2366: ,p_ap_invoice_lines_all_rec.TASK_ID
2367: ,p_ap_invoice_lines_all_rec.EXPENDITURE_TYPE
2368: ,p_ap_invoice_lines_all_rec.EXPENDITURE_ITEM_DATE
2369: ,p_ap_invoice_lines_all_rec.EXPENDITURE_ORGANIZATION_ID
2370: ,p_ap_invoice_lines_all_rec.PA_QUANTITY
2371: ,p_ap_invoice_lines_all_rec.PA_CC_AR_INVOICE_ID
2372: ,p_ap_invoice_lines_all_rec.PA_CC_AR_INVOICE_LINE_NUM

Line 2369: ,p_ap_invoice_lines_all_rec.EXPENDITURE_ORGANIZATION_ID

2365: ,p_ap_invoice_lines_all_rec.PROJECT_ID
2366: ,p_ap_invoice_lines_all_rec.TASK_ID
2367: ,p_ap_invoice_lines_all_rec.EXPENDITURE_TYPE
2368: ,p_ap_invoice_lines_all_rec.EXPENDITURE_ITEM_DATE
2369: ,p_ap_invoice_lines_all_rec.EXPENDITURE_ORGANIZATION_ID
2370: ,p_ap_invoice_lines_all_rec.PA_QUANTITY
2371: ,p_ap_invoice_lines_all_rec.PA_CC_AR_INVOICE_ID
2372: ,p_ap_invoice_lines_all_rec.PA_CC_AR_INVOICE_LINE_NUM
2373: ,p_ap_invoice_lines_all_rec.PA_CC_PROCESSED_CODE

Line 2370: ,p_ap_invoice_lines_all_rec.PA_QUANTITY

2366: ,p_ap_invoice_lines_all_rec.TASK_ID
2367: ,p_ap_invoice_lines_all_rec.EXPENDITURE_TYPE
2368: ,p_ap_invoice_lines_all_rec.EXPENDITURE_ITEM_DATE
2369: ,p_ap_invoice_lines_all_rec.EXPENDITURE_ORGANIZATION_ID
2370: ,p_ap_invoice_lines_all_rec.PA_QUANTITY
2371: ,p_ap_invoice_lines_all_rec.PA_CC_AR_INVOICE_ID
2372: ,p_ap_invoice_lines_all_rec.PA_CC_AR_INVOICE_LINE_NUM
2373: ,p_ap_invoice_lines_all_rec.PA_CC_PROCESSED_CODE
2374: ,p_ap_invoice_lines_all_rec.AWARD_ID

Line 2371: ,p_ap_invoice_lines_all_rec.PA_CC_AR_INVOICE_ID

2367: ,p_ap_invoice_lines_all_rec.EXPENDITURE_TYPE
2368: ,p_ap_invoice_lines_all_rec.EXPENDITURE_ITEM_DATE
2369: ,p_ap_invoice_lines_all_rec.EXPENDITURE_ORGANIZATION_ID
2370: ,p_ap_invoice_lines_all_rec.PA_QUANTITY
2371: ,p_ap_invoice_lines_all_rec.PA_CC_AR_INVOICE_ID
2372: ,p_ap_invoice_lines_all_rec.PA_CC_AR_INVOICE_LINE_NUM
2373: ,p_ap_invoice_lines_all_rec.PA_CC_PROCESSED_CODE
2374: ,p_ap_invoice_lines_all_rec.AWARD_ID
2375: ,p_ap_invoice_lines_all_rec.AWT_GROUP_ID

Line 2372: ,p_ap_invoice_lines_all_rec.PA_CC_AR_INVOICE_LINE_NUM

2368: ,p_ap_invoice_lines_all_rec.EXPENDITURE_ITEM_DATE
2369: ,p_ap_invoice_lines_all_rec.EXPENDITURE_ORGANIZATION_ID
2370: ,p_ap_invoice_lines_all_rec.PA_QUANTITY
2371: ,p_ap_invoice_lines_all_rec.PA_CC_AR_INVOICE_ID
2372: ,p_ap_invoice_lines_all_rec.PA_CC_AR_INVOICE_LINE_NUM
2373: ,p_ap_invoice_lines_all_rec.PA_CC_PROCESSED_CODE
2374: ,p_ap_invoice_lines_all_rec.AWARD_ID
2375: ,p_ap_invoice_lines_all_rec.AWT_GROUP_ID
2376: ,p_ap_invoice_lines_all_rec.REFERENCE_1

Line 2373: ,p_ap_invoice_lines_all_rec.PA_CC_PROCESSED_CODE

2369: ,p_ap_invoice_lines_all_rec.EXPENDITURE_ORGANIZATION_ID
2370: ,p_ap_invoice_lines_all_rec.PA_QUANTITY
2371: ,p_ap_invoice_lines_all_rec.PA_CC_AR_INVOICE_ID
2372: ,p_ap_invoice_lines_all_rec.PA_CC_AR_INVOICE_LINE_NUM
2373: ,p_ap_invoice_lines_all_rec.PA_CC_PROCESSED_CODE
2374: ,p_ap_invoice_lines_all_rec.AWARD_ID
2375: ,p_ap_invoice_lines_all_rec.AWT_GROUP_ID
2376: ,p_ap_invoice_lines_all_rec.REFERENCE_1
2377: ,p_ap_invoice_lines_all_rec.REFERENCE_2

Line 2374: ,p_ap_invoice_lines_all_rec.AWARD_ID

2370: ,p_ap_invoice_lines_all_rec.PA_QUANTITY
2371: ,p_ap_invoice_lines_all_rec.PA_CC_AR_INVOICE_ID
2372: ,p_ap_invoice_lines_all_rec.PA_CC_AR_INVOICE_LINE_NUM
2373: ,p_ap_invoice_lines_all_rec.PA_CC_PROCESSED_CODE
2374: ,p_ap_invoice_lines_all_rec.AWARD_ID
2375: ,p_ap_invoice_lines_all_rec.AWT_GROUP_ID
2376: ,p_ap_invoice_lines_all_rec.REFERENCE_1
2377: ,p_ap_invoice_lines_all_rec.REFERENCE_2
2378: ,p_ap_invoice_lines_all_rec.RECEIPT_VERIFIED_FLAG

Line 2375: ,p_ap_invoice_lines_all_rec.AWT_GROUP_ID

2371: ,p_ap_invoice_lines_all_rec.PA_CC_AR_INVOICE_ID
2372: ,p_ap_invoice_lines_all_rec.PA_CC_AR_INVOICE_LINE_NUM
2373: ,p_ap_invoice_lines_all_rec.PA_CC_PROCESSED_CODE
2374: ,p_ap_invoice_lines_all_rec.AWARD_ID
2375: ,p_ap_invoice_lines_all_rec.AWT_GROUP_ID
2376: ,p_ap_invoice_lines_all_rec.REFERENCE_1
2377: ,p_ap_invoice_lines_all_rec.REFERENCE_2
2378: ,p_ap_invoice_lines_all_rec.RECEIPT_VERIFIED_FLAG
2379: ,p_ap_invoice_lines_all_rec.RECEIPT_REQUIRED_FLAG

Line 2376: ,p_ap_invoice_lines_all_rec.REFERENCE_1

2372: ,p_ap_invoice_lines_all_rec.PA_CC_AR_INVOICE_LINE_NUM
2373: ,p_ap_invoice_lines_all_rec.PA_CC_PROCESSED_CODE
2374: ,p_ap_invoice_lines_all_rec.AWARD_ID
2375: ,p_ap_invoice_lines_all_rec.AWT_GROUP_ID
2376: ,p_ap_invoice_lines_all_rec.REFERENCE_1
2377: ,p_ap_invoice_lines_all_rec.REFERENCE_2
2378: ,p_ap_invoice_lines_all_rec.RECEIPT_VERIFIED_FLAG
2379: ,p_ap_invoice_lines_all_rec.RECEIPT_REQUIRED_FLAG
2380: ,p_ap_invoice_lines_all_rec.RECEIPT_MISSING_FLAG

Line 2377: ,p_ap_invoice_lines_all_rec.REFERENCE_2

2373: ,p_ap_invoice_lines_all_rec.PA_CC_PROCESSED_CODE
2374: ,p_ap_invoice_lines_all_rec.AWARD_ID
2375: ,p_ap_invoice_lines_all_rec.AWT_GROUP_ID
2376: ,p_ap_invoice_lines_all_rec.REFERENCE_1
2377: ,p_ap_invoice_lines_all_rec.REFERENCE_2
2378: ,p_ap_invoice_lines_all_rec.RECEIPT_VERIFIED_FLAG
2379: ,p_ap_invoice_lines_all_rec.RECEIPT_REQUIRED_FLAG
2380: ,p_ap_invoice_lines_all_rec.RECEIPT_MISSING_FLAG
2381: ,p_ap_invoice_lines_all_rec.JUSTIFICATION

Line 2378: ,p_ap_invoice_lines_all_rec.RECEIPT_VERIFIED_FLAG

2374: ,p_ap_invoice_lines_all_rec.AWARD_ID
2375: ,p_ap_invoice_lines_all_rec.AWT_GROUP_ID
2376: ,p_ap_invoice_lines_all_rec.REFERENCE_1
2377: ,p_ap_invoice_lines_all_rec.REFERENCE_2
2378: ,p_ap_invoice_lines_all_rec.RECEIPT_VERIFIED_FLAG
2379: ,p_ap_invoice_lines_all_rec.RECEIPT_REQUIRED_FLAG
2380: ,p_ap_invoice_lines_all_rec.RECEIPT_MISSING_FLAG
2381: ,p_ap_invoice_lines_all_rec.JUSTIFICATION
2382: ,p_ap_invoice_lines_all_rec.EXPENSE_GROUP

Line 2379: ,p_ap_invoice_lines_all_rec.RECEIPT_REQUIRED_FLAG

2375: ,p_ap_invoice_lines_all_rec.AWT_GROUP_ID
2376: ,p_ap_invoice_lines_all_rec.REFERENCE_1
2377: ,p_ap_invoice_lines_all_rec.REFERENCE_2
2378: ,p_ap_invoice_lines_all_rec.RECEIPT_VERIFIED_FLAG
2379: ,p_ap_invoice_lines_all_rec.RECEIPT_REQUIRED_FLAG
2380: ,p_ap_invoice_lines_all_rec.RECEIPT_MISSING_FLAG
2381: ,p_ap_invoice_lines_all_rec.JUSTIFICATION
2382: ,p_ap_invoice_lines_all_rec.EXPENSE_GROUP
2383: ,p_ap_invoice_lines_all_rec.START_EXPENSE_DATE

Line 2380: ,p_ap_invoice_lines_all_rec.RECEIPT_MISSING_FLAG

2376: ,p_ap_invoice_lines_all_rec.REFERENCE_1
2377: ,p_ap_invoice_lines_all_rec.REFERENCE_2
2378: ,p_ap_invoice_lines_all_rec.RECEIPT_VERIFIED_FLAG
2379: ,p_ap_invoice_lines_all_rec.RECEIPT_REQUIRED_FLAG
2380: ,p_ap_invoice_lines_all_rec.RECEIPT_MISSING_FLAG
2381: ,p_ap_invoice_lines_all_rec.JUSTIFICATION
2382: ,p_ap_invoice_lines_all_rec.EXPENSE_GROUP
2383: ,p_ap_invoice_lines_all_rec.START_EXPENSE_DATE
2384: ,p_ap_invoice_lines_all_rec.END_EXPENSE_DATE

Line 2381: ,p_ap_invoice_lines_all_rec.JUSTIFICATION

2377: ,p_ap_invoice_lines_all_rec.REFERENCE_2
2378: ,p_ap_invoice_lines_all_rec.RECEIPT_VERIFIED_FLAG
2379: ,p_ap_invoice_lines_all_rec.RECEIPT_REQUIRED_FLAG
2380: ,p_ap_invoice_lines_all_rec.RECEIPT_MISSING_FLAG
2381: ,p_ap_invoice_lines_all_rec.JUSTIFICATION
2382: ,p_ap_invoice_lines_all_rec.EXPENSE_GROUP
2383: ,p_ap_invoice_lines_all_rec.START_EXPENSE_DATE
2384: ,p_ap_invoice_lines_all_rec.END_EXPENSE_DATE
2385: ,p_ap_invoice_lines_all_rec.RECEIPT_CURRENCY_CODE

Line 2382: ,p_ap_invoice_lines_all_rec.EXPENSE_GROUP

2378: ,p_ap_invoice_lines_all_rec.RECEIPT_VERIFIED_FLAG
2379: ,p_ap_invoice_lines_all_rec.RECEIPT_REQUIRED_FLAG
2380: ,p_ap_invoice_lines_all_rec.RECEIPT_MISSING_FLAG
2381: ,p_ap_invoice_lines_all_rec.JUSTIFICATION
2382: ,p_ap_invoice_lines_all_rec.EXPENSE_GROUP
2383: ,p_ap_invoice_lines_all_rec.START_EXPENSE_DATE
2384: ,p_ap_invoice_lines_all_rec.END_EXPENSE_DATE
2385: ,p_ap_invoice_lines_all_rec.RECEIPT_CURRENCY_CODE
2386: ,p_ap_invoice_lines_all_rec.RECEIPT_CONVERSION_RATE

Line 2383: ,p_ap_invoice_lines_all_rec.START_EXPENSE_DATE

2379: ,p_ap_invoice_lines_all_rec.RECEIPT_REQUIRED_FLAG
2380: ,p_ap_invoice_lines_all_rec.RECEIPT_MISSING_FLAG
2381: ,p_ap_invoice_lines_all_rec.JUSTIFICATION
2382: ,p_ap_invoice_lines_all_rec.EXPENSE_GROUP
2383: ,p_ap_invoice_lines_all_rec.START_EXPENSE_DATE
2384: ,p_ap_invoice_lines_all_rec.END_EXPENSE_DATE
2385: ,p_ap_invoice_lines_all_rec.RECEIPT_CURRENCY_CODE
2386: ,p_ap_invoice_lines_all_rec.RECEIPT_CONVERSION_RATE
2387: ,p_ap_invoice_lines_all_rec.RECEIPT_CURRENCY_AMOUNT

Line 2384: ,p_ap_invoice_lines_all_rec.END_EXPENSE_DATE

2380: ,p_ap_invoice_lines_all_rec.RECEIPT_MISSING_FLAG
2381: ,p_ap_invoice_lines_all_rec.JUSTIFICATION
2382: ,p_ap_invoice_lines_all_rec.EXPENSE_GROUP
2383: ,p_ap_invoice_lines_all_rec.START_EXPENSE_DATE
2384: ,p_ap_invoice_lines_all_rec.END_EXPENSE_DATE
2385: ,p_ap_invoice_lines_all_rec.RECEIPT_CURRENCY_CODE
2386: ,p_ap_invoice_lines_all_rec.RECEIPT_CONVERSION_RATE
2387: ,p_ap_invoice_lines_all_rec.RECEIPT_CURRENCY_AMOUNT
2388: ,p_ap_invoice_lines_all_rec.DAILY_AMOUNT

Line 2385: ,p_ap_invoice_lines_all_rec.RECEIPT_CURRENCY_CODE

2381: ,p_ap_invoice_lines_all_rec.JUSTIFICATION
2382: ,p_ap_invoice_lines_all_rec.EXPENSE_GROUP
2383: ,p_ap_invoice_lines_all_rec.START_EXPENSE_DATE
2384: ,p_ap_invoice_lines_all_rec.END_EXPENSE_DATE
2385: ,p_ap_invoice_lines_all_rec.RECEIPT_CURRENCY_CODE
2386: ,p_ap_invoice_lines_all_rec.RECEIPT_CONVERSION_RATE
2387: ,p_ap_invoice_lines_all_rec.RECEIPT_CURRENCY_AMOUNT
2388: ,p_ap_invoice_lines_all_rec.DAILY_AMOUNT
2389: ,p_ap_invoice_lines_all_rec.WEB_PARAMETER_ID

Line 2386: ,p_ap_invoice_lines_all_rec.RECEIPT_CONVERSION_RATE

2382: ,p_ap_invoice_lines_all_rec.EXPENSE_GROUP
2383: ,p_ap_invoice_lines_all_rec.START_EXPENSE_DATE
2384: ,p_ap_invoice_lines_all_rec.END_EXPENSE_DATE
2385: ,p_ap_invoice_lines_all_rec.RECEIPT_CURRENCY_CODE
2386: ,p_ap_invoice_lines_all_rec.RECEIPT_CONVERSION_RATE
2387: ,p_ap_invoice_lines_all_rec.RECEIPT_CURRENCY_AMOUNT
2388: ,p_ap_invoice_lines_all_rec.DAILY_AMOUNT
2389: ,p_ap_invoice_lines_all_rec.WEB_PARAMETER_ID
2390: ,p_ap_invoice_lines_all_rec.ADJUSTMENT_REASON

Line 2387: ,p_ap_invoice_lines_all_rec.RECEIPT_CURRENCY_AMOUNT

2383: ,p_ap_invoice_lines_all_rec.START_EXPENSE_DATE
2384: ,p_ap_invoice_lines_all_rec.END_EXPENSE_DATE
2385: ,p_ap_invoice_lines_all_rec.RECEIPT_CURRENCY_CODE
2386: ,p_ap_invoice_lines_all_rec.RECEIPT_CONVERSION_RATE
2387: ,p_ap_invoice_lines_all_rec.RECEIPT_CURRENCY_AMOUNT
2388: ,p_ap_invoice_lines_all_rec.DAILY_AMOUNT
2389: ,p_ap_invoice_lines_all_rec.WEB_PARAMETER_ID
2390: ,p_ap_invoice_lines_all_rec.ADJUSTMENT_REASON
2391: ,p_ap_invoice_lines_all_rec.MERCHANT_DOCUMENT_NUMBER

Line 2388: ,p_ap_invoice_lines_all_rec.DAILY_AMOUNT

2384: ,p_ap_invoice_lines_all_rec.END_EXPENSE_DATE
2385: ,p_ap_invoice_lines_all_rec.RECEIPT_CURRENCY_CODE
2386: ,p_ap_invoice_lines_all_rec.RECEIPT_CONVERSION_RATE
2387: ,p_ap_invoice_lines_all_rec.RECEIPT_CURRENCY_AMOUNT
2388: ,p_ap_invoice_lines_all_rec.DAILY_AMOUNT
2389: ,p_ap_invoice_lines_all_rec.WEB_PARAMETER_ID
2390: ,p_ap_invoice_lines_all_rec.ADJUSTMENT_REASON
2391: ,p_ap_invoice_lines_all_rec.MERCHANT_DOCUMENT_NUMBER
2392: ,p_ap_invoice_lines_all_rec.MERCHANT_NAME

Line 2389: ,p_ap_invoice_lines_all_rec.WEB_PARAMETER_ID

2385: ,p_ap_invoice_lines_all_rec.RECEIPT_CURRENCY_CODE
2386: ,p_ap_invoice_lines_all_rec.RECEIPT_CONVERSION_RATE
2387: ,p_ap_invoice_lines_all_rec.RECEIPT_CURRENCY_AMOUNT
2388: ,p_ap_invoice_lines_all_rec.DAILY_AMOUNT
2389: ,p_ap_invoice_lines_all_rec.WEB_PARAMETER_ID
2390: ,p_ap_invoice_lines_all_rec.ADJUSTMENT_REASON
2391: ,p_ap_invoice_lines_all_rec.MERCHANT_DOCUMENT_NUMBER
2392: ,p_ap_invoice_lines_all_rec.MERCHANT_NAME
2393: ,p_ap_invoice_lines_all_rec.MERCHANT_REFERENCE

Line 2390: ,p_ap_invoice_lines_all_rec.ADJUSTMENT_REASON

2386: ,p_ap_invoice_lines_all_rec.RECEIPT_CONVERSION_RATE
2387: ,p_ap_invoice_lines_all_rec.RECEIPT_CURRENCY_AMOUNT
2388: ,p_ap_invoice_lines_all_rec.DAILY_AMOUNT
2389: ,p_ap_invoice_lines_all_rec.WEB_PARAMETER_ID
2390: ,p_ap_invoice_lines_all_rec.ADJUSTMENT_REASON
2391: ,p_ap_invoice_lines_all_rec.MERCHANT_DOCUMENT_NUMBER
2392: ,p_ap_invoice_lines_all_rec.MERCHANT_NAME
2393: ,p_ap_invoice_lines_all_rec.MERCHANT_REFERENCE
2394: ,p_ap_invoice_lines_all_rec.MERCHANT_TAX_REG_NUMBER

Line 2391: ,p_ap_invoice_lines_all_rec.MERCHANT_DOCUMENT_NUMBER

2387: ,p_ap_invoice_lines_all_rec.RECEIPT_CURRENCY_AMOUNT
2388: ,p_ap_invoice_lines_all_rec.DAILY_AMOUNT
2389: ,p_ap_invoice_lines_all_rec.WEB_PARAMETER_ID
2390: ,p_ap_invoice_lines_all_rec.ADJUSTMENT_REASON
2391: ,p_ap_invoice_lines_all_rec.MERCHANT_DOCUMENT_NUMBER
2392: ,p_ap_invoice_lines_all_rec.MERCHANT_NAME
2393: ,p_ap_invoice_lines_all_rec.MERCHANT_REFERENCE
2394: ,p_ap_invoice_lines_all_rec.MERCHANT_TAX_REG_NUMBER
2395: ,p_ap_invoice_lines_all_rec.MERCHANT_TAXPAYER_ID

Line 2392: ,p_ap_invoice_lines_all_rec.MERCHANT_NAME

2388: ,p_ap_invoice_lines_all_rec.DAILY_AMOUNT
2389: ,p_ap_invoice_lines_all_rec.WEB_PARAMETER_ID
2390: ,p_ap_invoice_lines_all_rec.ADJUSTMENT_REASON
2391: ,p_ap_invoice_lines_all_rec.MERCHANT_DOCUMENT_NUMBER
2392: ,p_ap_invoice_lines_all_rec.MERCHANT_NAME
2393: ,p_ap_invoice_lines_all_rec.MERCHANT_REFERENCE
2394: ,p_ap_invoice_lines_all_rec.MERCHANT_TAX_REG_NUMBER
2395: ,p_ap_invoice_lines_all_rec.MERCHANT_TAXPAYER_ID
2396: ,p_ap_invoice_lines_all_rec.COUNTRY_OF_SUPPLY

Line 2393: ,p_ap_invoice_lines_all_rec.MERCHANT_REFERENCE

2389: ,p_ap_invoice_lines_all_rec.WEB_PARAMETER_ID
2390: ,p_ap_invoice_lines_all_rec.ADJUSTMENT_REASON
2391: ,p_ap_invoice_lines_all_rec.MERCHANT_DOCUMENT_NUMBER
2392: ,p_ap_invoice_lines_all_rec.MERCHANT_NAME
2393: ,p_ap_invoice_lines_all_rec.MERCHANT_REFERENCE
2394: ,p_ap_invoice_lines_all_rec.MERCHANT_TAX_REG_NUMBER
2395: ,p_ap_invoice_lines_all_rec.MERCHANT_TAXPAYER_ID
2396: ,p_ap_invoice_lines_all_rec.COUNTRY_OF_SUPPLY
2397: ,p_ap_invoice_lines_all_rec.CREDIT_CARD_TRX_ID

Line 2394: ,p_ap_invoice_lines_all_rec.MERCHANT_TAX_REG_NUMBER

2390: ,p_ap_invoice_lines_all_rec.ADJUSTMENT_REASON
2391: ,p_ap_invoice_lines_all_rec.MERCHANT_DOCUMENT_NUMBER
2392: ,p_ap_invoice_lines_all_rec.MERCHANT_NAME
2393: ,p_ap_invoice_lines_all_rec.MERCHANT_REFERENCE
2394: ,p_ap_invoice_lines_all_rec.MERCHANT_TAX_REG_NUMBER
2395: ,p_ap_invoice_lines_all_rec.MERCHANT_TAXPAYER_ID
2396: ,p_ap_invoice_lines_all_rec.COUNTRY_OF_SUPPLY
2397: ,p_ap_invoice_lines_all_rec.CREDIT_CARD_TRX_ID
2398: ,p_ap_invoice_lines_all_rec.COMPANY_PREPAID_INVOICE_ID

Line 2395: ,p_ap_invoice_lines_all_rec.MERCHANT_TAXPAYER_ID

2391: ,p_ap_invoice_lines_all_rec.MERCHANT_DOCUMENT_NUMBER
2392: ,p_ap_invoice_lines_all_rec.MERCHANT_NAME
2393: ,p_ap_invoice_lines_all_rec.MERCHANT_REFERENCE
2394: ,p_ap_invoice_lines_all_rec.MERCHANT_TAX_REG_NUMBER
2395: ,p_ap_invoice_lines_all_rec.MERCHANT_TAXPAYER_ID
2396: ,p_ap_invoice_lines_all_rec.COUNTRY_OF_SUPPLY
2397: ,p_ap_invoice_lines_all_rec.CREDIT_CARD_TRX_ID
2398: ,p_ap_invoice_lines_all_rec.COMPANY_PREPAID_INVOICE_ID
2399: ,p_ap_invoice_lines_all_rec.CC_REVERSAL_FLAG

Line 2396: ,p_ap_invoice_lines_all_rec.COUNTRY_OF_SUPPLY

2392: ,p_ap_invoice_lines_all_rec.MERCHANT_NAME
2393: ,p_ap_invoice_lines_all_rec.MERCHANT_REFERENCE
2394: ,p_ap_invoice_lines_all_rec.MERCHANT_TAX_REG_NUMBER
2395: ,p_ap_invoice_lines_all_rec.MERCHANT_TAXPAYER_ID
2396: ,p_ap_invoice_lines_all_rec.COUNTRY_OF_SUPPLY
2397: ,p_ap_invoice_lines_all_rec.CREDIT_CARD_TRX_ID
2398: ,p_ap_invoice_lines_all_rec.COMPANY_PREPAID_INVOICE_ID
2399: ,p_ap_invoice_lines_all_rec.CC_REVERSAL_FLAG
2400: ,p_ap_invoice_lines_all_rec.CREATION_DATE

Line 2397: ,p_ap_invoice_lines_all_rec.CREDIT_CARD_TRX_ID

2393: ,p_ap_invoice_lines_all_rec.MERCHANT_REFERENCE
2394: ,p_ap_invoice_lines_all_rec.MERCHANT_TAX_REG_NUMBER
2395: ,p_ap_invoice_lines_all_rec.MERCHANT_TAXPAYER_ID
2396: ,p_ap_invoice_lines_all_rec.COUNTRY_OF_SUPPLY
2397: ,p_ap_invoice_lines_all_rec.CREDIT_CARD_TRX_ID
2398: ,p_ap_invoice_lines_all_rec.COMPANY_PREPAID_INVOICE_ID
2399: ,p_ap_invoice_lines_all_rec.CC_REVERSAL_FLAG
2400: ,p_ap_invoice_lines_all_rec.CREATION_DATE
2401: ,p_ap_invoice_lines_all_rec.CREATED_BY

Line 2398: ,p_ap_invoice_lines_all_rec.COMPANY_PREPAID_INVOICE_ID

2394: ,p_ap_invoice_lines_all_rec.MERCHANT_TAX_REG_NUMBER
2395: ,p_ap_invoice_lines_all_rec.MERCHANT_TAXPAYER_ID
2396: ,p_ap_invoice_lines_all_rec.COUNTRY_OF_SUPPLY
2397: ,p_ap_invoice_lines_all_rec.CREDIT_CARD_TRX_ID
2398: ,p_ap_invoice_lines_all_rec.COMPANY_PREPAID_INVOICE_ID
2399: ,p_ap_invoice_lines_all_rec.CC_REVERSAL_FLAG
2400: ,p_ap_invoice_lines_all_rec.CREATION_DATE
2401: ,p_ap_invoice_lines_all_rec.CREATED_BY
2402: ,p_ap_invoice_lines_all_rec.LAST_UPDATED_BY

Line 2399: ,p_ap_invoice_lines_all_rec.CC_REVERSAL_FLAG

2395: ,p_ap_invoice_lines_all_rec.MERCHANT_TAXPAYER_ID
2396: ,p_ap_invoice_lines_all_rec.COUNTRY_OF_SUPPLY
2397: ,p_ap_invoice_lines_all_rec.CREDIT_CARD_TRX_ID
2398: ,p_ap_invoice_lines_all_rec.COMPANY_PREPAID_INVOICE_ID
2399: ,p_ap_invoice_lines_all_rec.CC_REVERSAL_FLAG
2400: ,p_ap_invoice_lines_all_rec.CREATION_DATE
2401: ,p_ap_invoice_lines_all_rec.CREATED_BY
2402: ,p_ap_invoice_lines_all_rec.LAST_UPDATED_BY
2403: ,p_ap_invoice_lines_all_rec.LAST_UPDATE_DATE

Line 2400: ,p_ap_invoice_lines_all_rec.CREATION_DATE

2396: ,p_ap_invoice_lines_all_rec.COUNTRY_OF_SUPPLY
2397: ,p_ap_invoice_lines_all_rec.CREDIT_CARD_TRX_ID
2398: ,p_ap_invoice_lines_all_rec.COMPANY_PREPAID_INVOICE_ID
2399: ,p_ap_invoice_lines_all_rec.CC_REVERSAL_FLAG
2400: ,p_ap_invoice_lines_all_rec.CREATION_DATE
2401: ,p_ap_invoice_lines_all_rec.CREATED_BY
2402: ,p_ap_invoice_lines_all_rec.LAST_UPDATED_BY
2403: ,p_ap_invoice_lines_all_rec.LAST_UPDATE_DATE
2404: ,p_ap_invoice_lines_all_rec.LAST_UPDATE_LOGIN

Line 2401: ,p_ap_invoice_lines_all_rec.CREATED_BY

2397: ,p_ap_invoice_lines_all_rec.CREDIT_CARD_TRX_ID
2398: ,p_ap_invoice_lines_all_rec.COMPANY_PREPAID_INVOICE_ID
2399: ,p_ap_invoice_lines_all_rec.CC_REVERSAL_FLAG
2400: ,p_ap_invoice_lines_all_rec.CREATION_DATE
2401: ,p_ap_invoice_lines_all_rec.CREATED_BY
2402: ,p_ap_invoice_lines_all_rec.LAST_UPDATED_BY
2403: ,p_ap_invoice_lines_all_rec.LAST_UPDATE_DATE
2404: ,p_ap_invoice_lines_all_rec.LAST_UPDATE_LOGIN
2405: ,p_ap_invoice_lines_all_rec.PROGRAM_APPLICATION_ID

Line 2402: ,p_ap_invoice_lines_all_rec.LAST_UPDATED_BY

2398: ,p_ap_invoice_lines_all_rec.COMPANY_PREPAID_INVOICE_ID
2399: ,p_ap_invoice_lines_all_rec.CC_REVERSAL_FLAG
2400: ,p_ap_invoice_lines_all_rec.CREATION_DATE
2401: ,p_ap_invoice_lines_all_rec.CREATED_BY
2402: ,p_ap_invoice_lines_all_rec.LAST_UPDATED_BY
2403: ,p_ap_invoice_lines_all_rec.LAST_UPDATE_DATE
2404: ,p_ap_invoice_lines_all_rec.LAST_UPDATE_LOGIN
2405: ,p_ap_invoice_lines_all_rec.PROGRAM_APPLICATION_ID
2406: ,p_ap_invoice_lines_all_rec.PROGRAM_ID

Line 2403: ,p_ap_invoice_lines_all_rec.LAST_UPDATE_DATE

2399: ,p_ap_invoice_lines_all_rec.CC_REVERSAL_FLAG
2400: ,p_ap_invoice_lines_all_rec.CREATION_DATE
2401: ,p_ap_invoice_lines_all_rec.CREATED_BY
2402: ,p_ap_invoice_lines_all_rec.LAST_UPDATED_BY
2403: ,p_ap_invoice_lines_all_rec.LAST_UPDATE_DATE
2404: ,p_ap_invoice_lines_all_rec.LAST_UPDATE_LOGIN
2405: ,p_ap_invoice_lines_all_rec.PROGRAM_APPLICATION_ID
2406: ,p_ap_invoice_lines_all_rec.PROGRAM_ID
2407: ,p_ap_invoice_lines_all_rec.PROGRAM_UPDATE_DATE

Line 2404: ,p_ap_invoice_lines_all_rec.LAST_UPDATE_LOGIN

2400: ,p_ap_invoice_lines_all_rec.CREATION_DATE
2401: ,p_ap_invoice_lines_all_rec.CREATED_BY
2402: ,p_ap_invoice_lines_all_rec.LAST_UPDATED_BY
2403: ,p_ap_invoice_lines_all_rec.LAST_UPDATE_DATE
2404: ,p_ap_invoice_lines_all_rec.LAST_UPDATE_LOGIN
2405: ,p_ap_invoice_lines_all_rec.PROGRAM_APPLICATION_ID
2406: ,p_ap_invoice_lines_all_rec.PROGRAM_ID
2407: ,p_ap_invoice_lines_all_rec.PROGRAM_UPDATE_DATE
2408: ,p_ap_invoice_lines_all_rec.REQUEST_ID

Line 2405: ,p_ap_invoice_lines_all_rec.PROGRAM_APPLICATION_ID

2401: ,p_ap_invoice_lines_all_rec.CREATED_BY
2402: ,p_ap_invoice_lines_all_rec.LAST_UPDATED_BY
2403: ,p_ap_invoice_lines_all_rec.LAST_UPDATE_DATE
2404: ,p_ap_invoice_lines_all_rec.LAST_UPDATE_LOGIN
2405: ,p_ap_invoice_lines_all_rec.PROGRAM_APPLICATION_ID
2406: ,p_ap_invoice_lines_all_rec.PROGRAM_ID
2407: ,p_ap_invoice_lines_all_rec.PROGRAM_UPDATE_DATE
2408: ,p_ap_invoice_lines_all_rec.REQUEST_ID
2409: ,p_ap_invoice_lines_all_rec.ATTRIBUTE_CATEGORY

Line 2406: ,p_ap_invoice_lines_all_rec.PROGRAM_ID

2402: ,p_ap_invoice_lines_all_rec.LAST_UPDATED_BY
2403: ,p_ap_invoice_lines_all_rec.LAST_UPDATE_DATE
2404: ,p_ap_invoice_lines_all_rec.LAST_UPDATE_LOGIN
2405: ,p_ap_invoice_lines_all_rec.PROGRAM_APPLICATION_ID
2406: ,p_ap_invoice_lines_all_rec.PROGRAM_ID
2407: ,p_ap_invoice_lines_all_rec.PROGRAM_UPDATE_DATE
2408: ,p_ap_invoice_lines_all_rec.REQUEST_ID
2409: ,p_ap_invoice_lines_all_rec.ATTRIBUTE_CATEGORY
2410: ,p_ap_invoice_lines_all_rec.ATTRIBUTE1

Line 2407: ,p_ap_invoice_lines_all_rec.PROGRAM_UPDATE_DATE

2403: ,p_ap_invoice_lines_all_rec.LAST_UPDATE_DATE
2404: ,p_ap_invoice_lines_all_rec.LAST_UPDATE_LOGIN
2405: ,p_ap_invoice_lines_all_rec.PROGRAM_APPLICATION_ID
2406: ,p_ap_invoice_lines_all_rec.PROGRAM_ID
2407: ,p_ap_invoice_lines_all_rec.PROGRAM_UPDATE_DATE
2408: ,p_ap_invoice_lines_all_rec.REQUEST_ID
2409: ,p_ap_invoice_lines_all_rec.ATTRIBUTE_CATEGORY
2410: ,p_ap_invoice_lines_all_rec.ATTRIBUTE1
2411: ,p_ap_invoice_lines_all_rec.ATTRIBUTE2

Line 2408: ,p_ap_invoice_lines_all_rec.REQUEST_ID

2404: ,p_ap_invoice_lines_all_rec.LAST_UPDATE_LOGIN
2405: ,p_ap_invoice_lines_all_rec.PROGRAM_APPLICATION_ID
2406: ,p_ap_invoice_lines_all_rec.PROGRAM_ID
2407: ,p_ap_invoice_lines_all_rec.PROGRAM_UPDATE_DATE
2408: ,p_ap_invoice_lines_all_rec.REQUEST_ID
2409: ,p_ap_invoice_lines_all_rec.ATTRIBUTE_CATEGORY
2410: ,p_ap_invoice_lines_all_rec.ATTRIBUTE1
2411: ,p_ap_invoice_lines_all_rec.ATTRIBUTE2
2412: ,p_ap_invoice_lines_all_rec.ATTRIBUTE3

Line 2409: ,p_ap_invoice_lines_all_rec.ATTRIBUTE_CATEGORY

2405: ,p_ap_invoice_lines_all_rec.PROGRAM_APPLICATION_ID
2406: ,p_ap_invoice_lines_all_rec.PROGRAM_ID
2407: ,p_ap_invoice_lines_all_rec.PROGRAM_UPDATE_DATE
2408: ,p_ap_invoice_lines_all_rec.REQUEST_ID
2409: ,p_ap_invoice_lines_all_rec.ATTRIBUTE_CATEGORY
2410: ,p_ap_invoice_lines_all_rec.ATTRIBUTE1
2411: ,p_ap_invoice_lines_all_rec.ATTRIBUTE2
2412: ,p_ap_invoice_lines_all_rec.ATTRIBUTE3
2413: ,p_ap_invoice_lines_all_rec.ATTRIBUTE4

Line 2410: ,p_ap_invoice_lines_all_rec.ATTRIBUTE1

2406: ,p_ap_invoice_lines_all_rec.PROGRAM_ID
2407: ,p_ap_invoice_lines_all_rec.PROGRAM_UPDATE_DATE
2408: ,p_ap_invoice_lines_all_rec.REQUEST_ID
2409: ,p_ap_invoice_lines_all_rec.ATTRIBUTE_CATEGORY
2410: ,p_ap_invoice_lines_all_rec.ATTRIBUTE1
2411: ,p_ap_invoice_lines_all_rec.ATTRIBUTE2
2412: ,p_ap_invoice_lines_all_rec.ATTRIBUTE3
2413: ,p_ap_invoice_lines_all_rec.ATTRIBUTE4
2414: ,p_ap_invoice_lines_all_rec.ATTRIBUTE5

Line 2411: ,p_ap_invoice_lines_all_rec.ATTRIBUTE2

2407: ,p_ap_invoice_lines_all_rec.PROGRAM_UPDATE_DATE
2408: ,p_ap_invoice_lines_all_rec.REQUEST_ID
2409: ,p_ap_invoice_lines_all_rec.ATTRIBUTE_CATEGORY
2410: ,p_ap_invoice_lines_all_rec.ATTRIBUTE1
2411: ,p_ap_invoice_lines_all_rec.ATTRIBUTE2
2412: ,p_ap_invoice_lines_all_rec.ATTRIBUTE3
2413: ,p_ap_invoice_lines_all_rec.ATTRIBUTE4
2414: ,p_ap_invoice_lines_all_rec.ATTRIBUTE5
2415: ,p_ap_invoice_lines_all_rec.ATTRIBUTE6

Line 2412: ,p_ap_invoice_lines_all_rec.ATTRIBUTE3

2408: ,p_ap_invoice_lines_all_rec.REQUEST_ID
2409: ,p_ap_invoice_lines_all_rec.ATTRIBUTE_CATEGORY
2410: ,p_ap_invoice_lines_all_rec.ATTRIBUTE1
2411: ,p_ap_invoice_lines_all_rec.ATTRIBUTE2
2412: ,p_ap_invoice_lines_all_rec.ATTRIBUTE3
2413: ,p_ap_invoice_lines_all_rec.ATTRIBUTE4
2414: ,p_ap_invoice_lines_all_rec.ATTRIBUTE5
2415: ,p_ap_invoice_lines_all_rec.ATTRIBUTE6
2416: ,p_ap_invoice_lines_all_rec.ATTRIBUTE7

Line 2413: ,p_ap_invoice_lines_all_rec.ATTRIBUTE4

2409: ,p_ap_invoice_lines_all_rec.ATTRIBUTE_CATEGORY
2410: ,p_ap_invoice_lines_all_rec.ATTRIBUTE1
2411: ,p_ap_invoice_lines_all_rec.ATTRIBUTE2
2412: ,p_ap_invoice_lines_all_rec.ATTRIBUTE3
2413: ,p_ap_invoice_lines_all_rec.ATTRIBUTE4
2414: ,p_ap_invoice_lines_all_rec.ATTRIBUTE5
2415: ,p_ap_invoice_lines_all_rec.ATTRIBUTE6
2416: ,p_ap_invoice_lines_all_rec.ATTRIBUTE7
2417: ,p_ap_invoice_lines_all_rec.ATTRIBUTE8

Line 2414: ,p_ap_invoice_lines_all_rec.ATTRIBUTE5

2410: ,p_ap_invoice_lines_all_rec.ATTRIBUTE1
2411: ,p_ap_invoice_lines_all_rec.ATTRIBUTE2
2412: ,p_ap_invoice_lines_all_rec.ATTRIBUTE3
2413: ,p_ap_invoice_lines_all_rec.ATTRIBUTE4
2414: ,p_ap_invoice_lines_all_rec.ATTRIBUTE5
2415: ,p_ap_invoice_lines_all_rec.ATTRIBUTE6
2416: ,p_ap_invoice_lines_all_rec.ATTRIBUTE7
2417: ,p_ap_invoice_lines_all_rec.ATTRIBUTE8
2418: ,p_ap_invoice_lines_all_rec.ATTRIBUTE9

Line 2415: ,p_ap_invoice_lines_all_rec.ATTRIBUTE6

2411: ,p_ap_invoice_lines_all_rec.ATTRIBUTE2
2412: ,p_ap_invoice_lines_all_rec.ATTRIBUTE3
2413: ,p_ap_invoice_lines_all_rec.ATTRIBUTE4
2414: ,p_ap_invoice_lines_all_rec.ATTRIBUTE5
2415: ,p_ap_invoice_lines_all_rec.ATTRIBUTE6
2416: ,p_ap_invoice_lines_all_rec.ATTRIBUTE7
2417: ,p_ap_invoice_lines_all_rec.ATTRIBUTE8
2418: ,p_ap_invoice_lines_all_rec.ATTRIBUTE9
2419: ,p_ap_invoice_lines_all_rec.ATTRIBUTE10

Line 2416: ,p_ap_invoice_lines_all_rec.ATTRIBUTE7

2412: ,p_ap_invoice_lines_all_rec.ATTRIBUTE3
2413: ,p_ap_invoice_lines_all_rec.ATTRIBUTE4
2414: ,p_ap_invoice_lines_all_rec.ATTRIBUTE5
2415: ,p_ap_invoice_lines_all_rec.ATTRIBUTE6
2416: ,p_ap_invoice_lines_all_rec.ATTRIBUTE7
2417: ,p_ap_invoice_lines_all_rec.ATTRIBUTE8
2418: ,p_ap_invoice_lines_all_rec.ATTRIBUTE9
2419: ,p_ap_invoice_lines_all_rec.ATTRIBUTE10
2420: ,p_ap_invoice_lines_all_rec.ATTRIBUTE11

Line 2417: ,p_ap_invoice_lines_all_rec.ATTRIBUTE8

2413: ,p_ap_invoice_lines_all_rec.ATTRIBUTE4
2414: ,p_ap_invoice_lines_all_rec.ATTRIBUTE5
2415: ,p_ap_invoice_lines_all_rec.ATTRIBUTE6
2416: ,p_ap_invoice_lines_all_rec.ATTRIBUTE7
2417: ,p_ap_invoice_lines_all_rec.ATTRIBUTE8
2418: ,p_ap_invoice_lines_all_rec.ATTRIBUTE9
2419: ,p_ap_invoice_lines_all_rec.ATTRIBUTE10
2420: ,p_ap_invoice_lines_all_rec.ATTRIBUTE11
2421: ,p_ap_invoice_lines_all_rec.ATTRIBUTE12

Line 2418: ,p_ap_invoice_lines_all_rec.ATTRIBUTE9

2414: ,p_ap_invoice_lines_all_rec.ATTRIBUTE5
2415: ,p_ap_invoice_lines_all_rec.ATTRIBUTE6
2416: ,p_ap_invoice_lines_all_rec.ATTRIBUTE7
2417: ,p_ap_invoice_lines_all_rec.ATTRIBUTE8
2418: ,p_ap_invoice_lines_all_rec.ATTRIBUTE9
2419: ,p_ap_invoice_lines_all_rec.ATTRIBUTE10
2420: ,p_ap_invoice_lines_all_rec.ATTRIBUTE11
2421: ,p_ap_invoice_lines_all_rec.ATTRIBUTE12
2422: ,p_ap_invoice_lines_all_rec.ATTRIBUTE13

Line 2419: ,p_ap_invoice_lines_all_rec.ATTRIBUTE10

2415: ,p_ap_invoice_lines_all_rec.ATTRIBUTE6
2416: ,p_ap_invoice_lines_all_rec.ATTRIBUTE7
2417: ,p_ap_invoice_lines_all_rec.ATTRIBUTE8
2418: ,p_ap_invoice_lines_all_rec.ATTRIBUTE9
2419: ,p_ap_invoice_lines_all_rec.ATTRIBUTE10
2420: ,p_ap_invoice_lines_all_rec.ATTRIBUTE11
2421: ,p_ap_invoice_lines_all_rec.ATTRIBUTE12
2422: ,p_ap_invoice_lines_all_rec.ATTRIBUTE13
2423: ,p_ap_invoice_lines_all_rec.ATTRIBUTE14

Line 2420: ,p_ap_invoice_lines_all_rec.ATTRIBUTE11

2416: ,p_ap_invoice_lines_all_rec.ATTRIBUTE7
2417: ,p_ap_invoice_lines_all_rec.ATTRIBUTE8
2418: ,p_ap_invoice_lines_all_rec.ATTRIBUTE9
2419: ,p_ap_invoice_lines_all_rec.ATTRIBUTE10
2420: ,p_ap_invoice_lines_all_rec.ATTRIBUTE11
2421: ,p_ap_invoice_lines_all_rec.ATTRIBUTE12
2422: ,p_ap_invoice_lines_all_rec.ATTRIBUTE13
2423: ,p_ap_invoice_lines_all_rec.ATTRIBUTE14
2424: ,p_ap_invoice_lines_all_rec.ATTRIBUTE15

Line 2421: ,p_ap_invoice_lines_all_rec.ATTRIBUTE12

2417: ,p_ap_invoice_lines_all_rec.ATTRIBUTE8
2418: ,p_ap_invoice_lines_all_rec.ATTRIBUTE9
2419: ,p_ap_invoice_lines_all_rec.ATTRIBUTE10
2420: ,p_ap_invoice_lines_all_rec.ATTRIBUTE11
2421: ,p_ap_invoice_lines_all_rec.ATTRIBUTE12
2422: ,p_ap_invoice_lines_all_rec.ATTRIBUTE13
2423: ,p_ap_invoice_lines_all_rec.ATTRIBUTE14
2424: ,p_ap_invoice_lines_all_rec.ATTRIBUTE15
2425: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE_CATEGORY

Line 2422: ,p_ap_invoice_lines_all_rec.ATTRIBUTE13

2418: ,p_ap_invoice_lines_all_rec.ATTRIBUTE9
2419: ,p_ap_invoice_lines_all_rec.ATTRIBUTE10
2420: ,p_ap_invoice_lines_all_rec.ATTRIBUTE11
2421: ,p_ap_invoice_lines_all_rec.ATTRIBUTE12
2422: ,p_ap_invoice_lines_all_rec.ATTRIBUTE13
2423: ,p_ap_invoice_lines_all_rec.ATTRIBUTE14
2424: ,p_ap_invoice_lines_all_rec.ATTRIBUTE15
2425: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE_CATEGORY
2426: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE1

Line 2423: ,p_ap_invoice_lines_all_rec.ATTRIBUTE14

2419: ,p_ap_invoice_lines_all_rec.ATTRIBUTE10
2420: ,p_ap_invoice_lines_all_rec.ATTRIBUTE11
2421: ,p_ap_invoice_lines_all_rec.ATTRIBUTE12
2422: ,p_ap_invoice_lines_all_rec.ATTRIBUTE13
2423: ,p_ap_invoice_lines_all_rec.ATTRIBUTE14
2424: ,p_ap_invoice_lines_all_rec.ATTRIBUTE15
2425: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE_CATEGORY
2426: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE1
2427: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE2

Line 2424: ,p_ap_invoice_lines_all_rec.ATTRIBUTE15

2420: ,p_ap_invoice_lines_all_rec.ATTRIBUTE11
2421: ,p_ap_invoice_lines_all_rec.ATTRIBUTE12
2422: ,p_ap_invoice_lines_all_rec.ATTRIBUTE13
2423: ,p_ap_invoice_lines_all_rec.ATTRIBUTE14
2424: ,p_ap_invoice_lines_all_rec.ATTRIBUTE15
2425: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE_CATEGORY
2426: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE1
2427: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE2
2428: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE3

Line 2425: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE_CATEGORY

2421: ,p_ap_invoice_lines_all_rec.ATTRIBUTE12
2422: ,p_ap_invoice_lines_all_rec.ATTRIBUTE13
2423: ,p_ap_invoice_lines_all_rec.ATTRIBUTE14
2424: ,p_ap_invoice_lines_all_rec.ATTRIBUTE15
2425: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE_CATEGORY
2426: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE1
2427: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE2
2428: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE3
2429: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE4

Line 2426: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE1

2422: ,p_ap_invoice_lines_all_rec.ATTRIBUTE13
2423: ,p_ap_invoice_lines_all_rec.ATTRIBUTE14
2424: ,p_ap_invoice_lines_all_rec.ATTRIBUTE15
2425: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE_CATEGORY
2426: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE1
2427: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE2
2428: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE3
2429: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE4
2430: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE5

Line 2427: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE2

2423: ,p_ap_invoice_lines_all_rec.ATTRIBUTE14
2424: ,p_ap_invoice_lines_all_rec.ATTRIBUTE15
2425: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE_CATEGORY
2426: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE1
2427: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE2
2428: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE3
2429: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE4
2430: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE5
2431: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE6

Line 2428: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE3

2424: ,p_ap_invoice_lines_all_rec.ATTRIBUTE15
2425: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE_CATEGORY
2426: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE1
2427: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE2
2428: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE3
2429: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE4
2430: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE5
2431: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE6
2432: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE7

Line 2429: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE4

2425: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE_CATEGORY
2426: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE1
2427: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE2
2428: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE3
2429: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE4
2430: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE5
2431: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE6
2432: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE7
2433: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE8

Line 2430: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE5

2426: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE1
2427: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE2
2428: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE3
2429: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE4
2430: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE5
2431: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE6
2432: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE7
2433: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE8
2434: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE9

Line 2431: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE6

2427: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE2
2428: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE3
2429: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE4
2430: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE5
2431: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE6
2432: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE7
2433: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE8
2434: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE9
2435: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE10

Line 2432: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE7

2428: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE3
2429: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE4
2430: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE5
2431: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE6
2432: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE7
2433: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE8
2434: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE9
2435: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE10
2436: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE11

Line 2433: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE8

2429: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE4
2430: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE5
2431: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE6
2432: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE7
2433: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE8
2434: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE9
2435: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE10
2436: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE11
2437: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE12

Line 2434: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE9

2430: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE5
2431: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE6
2432: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE7
2433: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE8
2434: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE9
2435: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE10
2436: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE11
2437: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE12
2438: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE13

Line 2435: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE10

2431: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE6
2432: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE7
2433: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE8
2434: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE9
2435: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE10
2436: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE11
2437: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE12
2438: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE13
2439: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE14

Line 2436: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE11

2432: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE7
2433: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE8
2434: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE9
2435: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE10
2436: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE11
2437: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE12
2438: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE13
2439: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE14
2440: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE15

Line 2437: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE12

2433: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE8
2434: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE9
2435: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE10
2436: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE11
2437: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE12
2438: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE13
2439: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE14
2440: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE15
2441: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE16

Line 2438: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE13

2434: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE9
2435: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE10
2436: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE11
2437: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE12
2438: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE13
2439: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE14
2440: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE15
2441: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE16
2442: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE17

Line 2439: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE14

2435: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE10
2436: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE11
2437: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE12
2438: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE13
2439: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE14
2440: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE15
2441: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE16
2442: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE17
2443: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE18

Line 2440: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE15

2436: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE11
2437: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE12
2438: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE13
2439: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE14
2440: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE15
2441: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE16
2442: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE17
2443: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE18
2444: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE19

Line 2441: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE16

2437: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE12
2438: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE13
2439: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE14
2440: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE15
2441: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE16
2442: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE17
2443: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE18
2444: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE19
2445: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE20

Line 2442: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE17

2438: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE13
2439: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE14
2440: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE15
2441: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE16
2442: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE17
2443: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE18
2444: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE19
2445: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE20
2446: ,p_ap_invoice_lines_all_rec.LINE_SELECTED_FOR_APPL_FLAG

Line 2443: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE18

2439: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE14
2440: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE15
2441: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE16
2442: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE17
2443: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE18
2444: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE19
2445: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE20
2446: ,p_ap_invoice_lines_all_rec.LINE_SELECTED_FOR_APPL_FLAG
2447: ,p_ap_invoice_lines_all_rec.PREPAY_APPL_REQUEST_ID

Line 2444: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE19

2440: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE15
2441: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE16
2442: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE17
2443: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE18
2444: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE19
2445: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE20
2446: ,p_ap_invoice_lines_all_rec.LINE_SELECTED_FOR_APPL_FLAG
2447: ,p_ap_invoice_lines_all_rec.PREPAY_APPL_REQUEST_ID
2448: ,p_ap_invoice_lines_all_rec.APPLICATION_ID

Line 2445: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE20

2441: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE16
2442: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE17
2443: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE18
2444: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE19
2445: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE20
2446: ,p_ap_invoice_lines_all_rec.LINE_SELECTED_FOR_APPL_FLAG
2447: ,p_ap_invoice_lines_all_rec.PREPAY_APPL_REQUEST_ID
2448: ,p_ap_invoice_lines_all_rec.APPLICATION_ID
2449: ,p_ap_invoice_lines_all_rec.PRODUCT_TABLE

Line 2446: ,p_ap_invoice_lines_all_rec.LINE_SELECTED_FOR_APPL_FLAG

2442: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE17
2443: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE18
2444: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE19
2445: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE20
2446: ,p_ap_invoice_lines_all_rec.LINE_SELECTED_FOR_APPL_FLAG
2447: ,p_ap_invoice_lines_all_rec.PREPAY_APPL_REQUEST_ID
2448: ,p_ap_invoice_lines_all_rec.APPLICATION_ID
2449: ,p_ap_invoice_lines_all_rec.PRODUCT_TABLE
2450: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY1

Line 2447: ,p_ap_invoice_lines_all_rec.PREPAY_APPL_REQUEST_ID

2443: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE18
2444: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE19
2445: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE20
2446: ,p_ap_invoice_lines_all_rec.LINE_SELECTED_FOR_APPL_FLAG
2447: ,p_ap_invoice_lines_all_rec.PREPAY_APPL_REQUEST_ID
2448: ,p_ap_invoice_lines_all_rec.APPLICATION_ID
2449: ,p_ap_invoice_lines_all_rec.PRODUCT_TABLE
2450: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY1
2451: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY2

Line 2448: ,p_ap_invoice_lines_all_rec.APPLICATION_ID

2444: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE19
2445: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE20
2446: ,p_ap_invoice_lines_all_rec.LINE_SELECTED_FOR_APPL_FLAG
2447: ,p_ap_invoice_lines_all_rec.PREPAY_APPL_REQUEST_ID
2448: ,p_ap_invoice_lines_all_rec.APPLICATION_ID
2449: ,p_ap_invoice_lines_all_rec.PRODUCT_TABLE
2450: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY1
2451: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY2
2452: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY3

Line 2449: ,p_ap_invoice_lines_all_rec.PRODUCT_TABLE

2445: ,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE20
2446: ,p_ap_invoice_lines_all_rec.LINE_SELECTED_FOR_APPL_FLAG
2447: ,p_ap_invoice_lines_all_rec.PREPAY_APPL_REQUEST_ID
2448: ,p_ap_invoice_lines_all_rec.APPLICATION_ID
2449: ,p_ap_invoice_lines_all_rec.PRODUCT_TABLE
2450: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY1
2451: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY2
2452: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY3
2453: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY4

Line 2450: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY1

2446: ,p_ap_invoice_lines_all_rec.LINE_SELECTED_FOR_APPL_FLAG
2447: ,p_ap_invoice_lines_all_rec.PREPAY_APPL_REQUEST_ID
2448: ,p_ap_invoice_lines_all_rec.APPLICATION_ID
2449: ,p_ap_invoice_lines_all_rec.PRODUCT_TABLE
2450: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY1
2451: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY2
2452: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY3
2453: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY4
2454: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY5

Line 2451: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY2

2447: ,p_ap_invoice_lines_all_rec.PREPAY_APPL_REQUEST_ID
2448: ,p_ap_invoice_lines_all_rec.APPLICATION_ID
2449: ,p_ap_invoice_lines_all_rec.PRODUCT_TABLE
2450: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY1
2451: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY2
2452: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY3
2453: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY4
2454: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY5
2455: ,p_ap_invoice_lines_all_rec.PURCHASING_CATEGORY_ID

Line 2452: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY3

2448: ,p_ap_invoice_lines_all_rec.APPLICATION_ID
2449: ,p_ap_invoice_lines_all_rec.PRODUCT_TABLE
2450: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY1
2451: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY2
2452: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY3
2453: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY4
2454: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY5
2455: ,p_ap_invoice_lines_all_rec.PURCHASING_CATEGORY_ID
2456: ,p_ap_invoice_lines_all_rec.COST_FACTOR_ID

Line 2453: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY4

2449: ,p_ap_invoice_lines_all_rec.PRODUCT_TABLE
2450: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY1
2451: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY2
2452: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY3
2453: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY4
2454: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY5
2455: ,p_ap_invoice_lines_all_rec.PURCHASING_CATEGORY_ID
2456: ,p_ap_invoice_lines_all_rec.COST_FACTOR_ID
2457: ,p_ap_invoice_lines_all_rec.CONTROL_AMOUNT

Line 2454: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY5

2450: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY1
2451: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY2
2452: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY3
2453: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY4
2454: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY5
2455: ,p_ap_invoice_lines_all_rec.PURCHASING_CATEGORY_ID
2456: ,p_ap_invoice_lines_all_rec.COST_FACTOR_ID
2457: ,p_ap_invoice_lines_all_rec.CONTROL_AMOUNT
2458: ,p_ap_invoice_lines_all_rec.ASSESSABLE_VALUE

Line 2455: ,p_ap_invoice_lines_all_rec.PURCHASING_CATEGORY_ID

2451: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY2
2452: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY3
2453: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY4
2454: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY5
2455: ,p_ap_invoice_lines_all_rec.PURCHASING_CATEGORY_ID
2456: ,p_ap_invoice_lines_all_rec.COST_FACTOR_ID
2457: ,p_ap_invoice_lines_all_rec.CONTROL_AMOUNT
2458: ,p_ap_invoice_lines_all_rec.ASSESSABLE_VALUE
2459: ,p_ap_invoice_lines_all_rec.TOTAL_REC_TAX_AMOUNT

Line 2456: ,p_ap_invoice_lines_all_rec.COST_FACTOR_ID

2452: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY3
2453: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY4
2454: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY5
2455: ,p_ap_invoice_lines_all_rec.PURCHASING_CATEGORY_ID
2456: ,p_ap_invoice_lines_all_rec.COST_FACTOR_ID
2457: ,p_ap_invoice_lines_all_rec.CONTROL_AMOUNT
2458: ,p_ap_invoice_lines_all_rec.ASSESSABLE_VALUE
2459: ,p_ap_invoice_lines_all_rec.TOTAL_REC_TAX_AMOUNT
2460: ,p_ap_invoice_lines_all_rec.TOTAL_NREC_TAX_AMOUNT

Line 2457: ,p_ap_invoice_lines_all_rec.CONTROL_AMOUNT

2453: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY4
2454: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY5
2455: ,p_ap_invoice_lines_all_rec.PURCHASING_CATEGORY_ID
2456: ,p_ap_invoice_lines_all_rec.COST_FACTOR_ID
2457: ,p_ap_invoice_lines_all_rec.CONTROL_AMOUNT
2458: ,p_ap_invoice_lines_all_rec.ASSESSABLE_VALUE
2459: ,p_ap_invoice_lines_all_rec.TOTAL_REC_TAX_AMOUNT
2460: ,p_ap_invoice_lines_all_rec.TOTAL_NREC_TAX_AMOUNT
2461: ,p_ap_invoice_lines_all_rec.TOTAL_REC_TAX_AMT_FUNCL_CURR

Line 2458: ,p_ap_invoice_lines_all_rec.ASSESSABLE_VALUE

2454: ,p_ap_invoice_lines_all_rec.REFERENCE_KEY5
2455: ,p_ap_invoice_lines_all_rec.PURCHASING_CATEGORY_ID
2456: ,p_ap_invoice_lines_all_rec.COST_FACTOR_ID
2457: ,p_ap_invoice_lines_all_rec.CONTROL_AMOUNT
2458: ,p_ap_invoice_lines_all_rec.ASSESSABLE_VALUE
2459: ,p_ap_invoice_lines_all_rec.TOTAL_REC_TAX_AMOUNT
2460: ,p_ap_invoice_lines_all_rec.TOTAL_NREC_TAX_AMOUNT
2461: ,p_ap_invoice_lines_all_rec.TOTAL_REC_TAX_AMT_FUNCL_CURR
2462: ,p_ap_invoice_lines_all_rec.TOTAL_NREC_TAX_AMT_FUNCL_CURR

Line 2459: ,p_ap_invoice_lines_all_rec.TOTAL_REC_TAX_AMOUNT

2455: ,p_ap_invoice_lines_all_rec.PURCHASING_CATEGORY_ID
2456: ,p_ap_invoice_lines_all_rec.COST_FACTOR_ID
2457: ,p_ap_invoice_lines_all_rec.CONTROL_AMOUNT
2458: ,p_ap_invoice_lines_all_rec.ASSESSABLE_VALUE
2459: ,p_ap_invoice_lines_all_rec.TOTAL_REC_TAX_AMOUNT
2460: ,p_ap_invoice_lines_all_rec.TOTAL_NREC_TAX_AMOUNT
2461: ,p_ap_invoice_lines_all_rec.TOTAL_REC_TAX_AMT_FUNCL_CURR
2462: ,p_ap_invoice_lines_all_rec.TOTAL_NREC_TAX_AMT_FUNCL_CURR
2463: ,p_ap_invoice_lines_all_rec.INCLUDED_TAX_AMOUNT

Line 2460: ,p_ap_invoice_lines_all_rec.TOTAL_NREC_TAX_AMOUNT

2456: ,p_ap_invoice_lines_all_rec.COST_FACTOR_ID
2457: ,p_ap_invoice_lines_all_rec.CONTROL_AMOUNT
2458: ,p_ap_invoice_lines_all_rec.ASSESSABLE_VALUE
2459: ,p_ap_invoice_lines_all_rec.TOTAL_REC_TAX_AMOUNT
2460: ,p_ap_invoice_lines_all_rec.TOTAL_NREC_TAX_AMOUNT
2461: ,p_ap_invoice_lines_all_rec.TOTAL_REC_TAX_AMT_FUNCL_CURR
2462: ,p_ap_invoice_lines_all_rec.TOTAL_NREC_TAX_AMT_FUNCL_CURR
2463: ,p_ap_invoice_lines_all_rec.INCLUDED_TAX_AMOUNT
2464: ,p_ap_invoice_lines_all_rec.PRIMARY_INTENDED_USE

Line 2461: ,p_ap_invoice_lines_all_rec.TOTAL_REC_TAX_AMT_FUNCL_CURR

2457: ,p_ap_invoice_lines_all_rec.CONTROL_AMOUNT
2458: ,p_ap_invoice_lines_all_rec.ASSESSABLE_VALUE
2459: ,p_ap_invoice_lines_all_rec.TOTAL_REC_TAX_AMOUNT
2460: ,p_ap_invoice_lines_all_rec.TOTAL_NREC_TAX_AMOUNT
2461: ,p_ap_invoice_lines_all_rec.TOTAL_REC_TAX_AMT_FUNCL_CURR
2462: ,p_ap_invoice_lines_all_rec.TOTAL_NREC_TAX_AMT_FUNCL_CURR
2463: ,p_ap_invoice_lines_all_rec.INCLUDED_TAX_AMOUNT
2464: ,p_ap_invoice_lines_all_rec.PRIMARY_INTENDED_USE
2465: ,p_ap_invoice_lines_all_rec.TAX_ALREADY_CALCULATED_FLAG

Line 2462: ,p_ap_invoice_lines_all_rec.TOTAL_NREC_TAX_AMT_FUNCL_CURR

2458: ,p_ap_invoice_lines_all_rec.ASSESSABLE_VALUE
2459: ,p_ap_invoice_lines_all_rec.TOTAL_REC_TAX_AMOUNT
2460: ,p_ap_invoice_lines_all_rec.TOTAL_NREC_TAX_AMOUNT
2461: ,p_ap_invoice_lines_all_rec.TOTAL_REC_TAX_AMT_FUNCL_CURR
2462: ,p_ap_invoice_lines_all_rec.TOTAL_NREC_TAX_AMT_FUNCL_CURR
2463: ,p_ap_invoice_lines_all_rec.INCLUDED_TAX_AMOUNT
2464: ,p_ap_invoice_lines_all_rec.PRIMARY_INTENDED_USE
2465: ,p_ap_invoice_lines_all_rec.TAX_ALREADY_CALCULATED_FLAG
2466: ,p_ap_invoice_lines_all_rec.SHIP_TO_LOCATION_ID

Line 2463: ,p_ap_invoice_lines_all_rec.INCLUDED_TAX_AMOUNT

2459: ,p_ap_invoice_lines_all_rec.TOTAL_REC_TAX_AMOUNT
2460: ,p_ap_invoice_lines_all_rec.TOTAL_NREC_TAX_AMOUNT
2461: ,p_ap_invoice_lines_all_rec.TOTAL_REC_TAX_AMT_FUNCL_CURR
2462: ,p_ap_invoice_lines_all_rec.TOTAL_NREC_TAX_AMT_FUNCL_CURR
2463: ,p_ap_invoice_lines_all_rec.INCLUDED_TAX_AMOUNT
2464: ,p_ap_invoice_lines_all_rec.PRIMARY_INTENDED_USE
2465: ,p_ap_invoice_lines_all_rec.TAX_ALREADY_CALCULATED_FLAG
2466: ,p_ap_invoice_lines_all_rec.SHIP_TO_LOCATION_ID
2467: ,p_ap_invoice_lines_all_rec.PRODUCT_TYPE

Line 2464: ,p_ap_invoice_lines_all_rec.PRIMARY_INTENDED_USE

2460: ,p_ap_invoice_lines_all_rec.TOTAL_NREC_TAX_AMOUNT
2461: ,p_ap_invoice_lines_all_rec.TOTAL_REC_TAX_AMT_FUNCL_CURR
2462: ,p_ap_invoice_lines_all_rec.TOTAL_NREC_TAX_AMT_FUNCL_CURR
2463: ,p_ap_invoice_lines_all_rec.INCLUDED_TAX_AMOUNT
2464: ,p_ap_invoice_lines_all_rec.PRIMARY_INTENDED_USE
2465: ,p_ap_invoice_lines_all_rec.TAX_ALREADY_CALCULATED_FLAG
2466: ,p_ap_invoice_lines_all_rec.SHIP_TO_LOCATION_ID
2467: ,p_ap_invoice_lines_all_rec.PRODUCT_TYPE
2468: ,p_ap_invoice_lines_all_rec.PRODUCT_CATEGORY

Line 2465: ,p_ap_invoice_lines_all_rec.TAX_ALREADY_CALCULATED_FLAG

2461: ,p_ap_invoice_lines_all_rec.TOTAL_REC_TAX_AMT_FUNCL_CURR
2462: ,p_ap_invoice_lines_all_rec.TOTAL_NREC_TAX_AMT_FUNCL_CURR
2463: ,p_ap_invoice_lines_all_rec.INCLUDED_TAX_AMOUNT
2464: ,p_ap_invoice_lines_all_rec.PRIMARY_INTENDED_USE
2465: ,p_ap_invoice_lines_all_rec.TAX_ALREADY_CALCULATED_FLAG
2466: ,p_ap_invoice_lines_all_rec.SHIP_TO_LOCATION_ID
2467: ,p_ap_invoice_lines_all_rec.PRODUCT_TYPE
2468: ,p_ap_invoice_lines_all_rec.PRODUCT_CATEGORY
2469: ,p_ap_invoice_lines_all_rec.PRODUCT_FISC_CLASSIFICATION

Line 2466: ,p_ap_invoice_lines_all_rec.SHIP_TO_LOCATION_ID

2462: ,p_ap_invoice_lines_all_rec.TOTAL_NREC_TAX_AMT_FUNCL_CURR
2463: ,p_ap_invoice_lines_all_rec.INCLUDED_TAX_AMOUNT
2464: ,p_ap_invoice_lines_all_rec.PRIMARY_INTENDED_USE
2465: ,p_ap_invoice_lines_all_rec.TAX_ALREADY_CALCULATED_FLAG
2466: ,p_ap_invoice_lines_all_rec.SHIP_TO_LOCATION_ID
2467: ,p_ap_invoice_lines_all_rec.PRODUCT_TYPE
2468: ,p_ap_invoice_lines_all_rec.PRODUCT_CATEGORY
2469: ,p_ap_invoice_lines_all_rec.PRODUCT_FISC_CLASSIFICATION
2470: ,p_ap_invoice_lines_all_rec.USER_DEFINED_FISC_CLASS

Line 2467: ,p_ap_invoice_lines_all_rec.PRODUCT_TYPE

2463: ,p_ap_invoice_lines_all_rec.INCLUDED_TAX_AMOUNT
2464: ,p_ap_invoice_lines_all_rec.PRIMARY_INTENDED_USE
2465: ,p_ap_invoice_lines_all_rec.TAX_ALREADY_CALCULATED_FLAG
2466: ,p_ap_invoice_lines_all_rec.SHIP_TO_LOCATION_ID
2467: ,p_ap_invoice_lines_all_rec.PRODUCT_TYPE
2468: ,p_ap_invoice_lines_all_rec.PRODUCT_CATEGORY
2469: ,p_ap_invoice_lines_all_rec.PRODUCT_FISC_CLASSIFICATION
2470: ,p_ap_invoice_lines_all_rec.USER_DEFINED_FISC_CLASS
2471: ,p_ap_invoice_lines_all_rec.TRX_BUSINESS_CATEGORY

Line 2468: ,p_ap_invoice_lines_all_rec.PRODUCT_CATEGORY

2464: ,p_ap_invoice_lines_all_rec.PRIMARY_INTENDED_USE
2465: ,p_ap_invoice_lines_all_rec.TAX_ALREADY_CALCULATED_FLAG
2466: ,p_ap_invoice_lines_all_rec.SHIP_TO_LOCATION_ID
2467: ,p_ap_invoice_lines_all_rec.PRODUCT_TYPE
2468: ,p_ap_invoice_lines_all_rec.PRODUCT_CATEGORY
2469: ,p_ap_invoice_lines_all_rec.PRODUCT_FISC_CLASSIFICATION
2470: ,p_ap_invoice_lines_all_rec.USER_DEFINED_FISC_CLASS
2471: ,p_ap_invoice_lines_all_rec.TRX_BUSINESS_CATEGORY
2472: ,p_ap_invoice_lines_all_rec.SUMMARY_TAX_LINE_ID

Line 2469: ,p_ap_invoice_lines_all_rec.PRODUCT_FISC_CLASSIFICATION

2465: ,p_ap_invoice_lines_all_rec.TAX_ALREADY_CALCULATED_FLAG
2466: ,p_ap_invoice_lines_all_rec.SHIP_TO_LOCATION_ID
2467: ,p_ap_invoice_lines_all_rec.PRODUCT_TYPE
2468: ,p_ap_invoice_lines_all_rec.PRODUCT_CATEGORY
2469: ,p_ap_invoice_lines_all_rec.PRODUCT_FISC_CLASSIFICATION
2470: ,p_ap_invoice_lines_all_rec.USER_DEFINED_FISC_CLASS
2471: ,p_ap_invoice_lines_all_rec.TRX_BUSINESS_CATEGORY
2472: ,p_ap_invoice_lines_all_rec.SUMMARY_TAX_LINE_ID
2473: ,p_ap_invoice_lines_all_rec.TAX_REGIME_CODE

Line 2470: ,p_ap_invoice_lines_all_rec.USER_DEFINED_FISC_CLASS

2466: ,p_ap_invoice_lines_all_rec.SHIP_TO_LOCATION_ID
2467: ,p_ap_invoice_lines_all_rec.PRODUCT_TYPE
2468: ,p_ap_invoice_lines_all_rec.PRODUCT_CATEGORY
2469: ,p_ap_invoice_lines_all_rec.PRODUCT_FISC_CLASSIFICATION
2470: ,p_ap_invoice_lines_all_rec.USER_DEFINED_FISC_CLASS
2471: ,p_ap_invoice_lines_all_rec.TRX_BUSINESS_CATEGORY
2472: ,p_ap_invoice_lines_all_rec.SUMMARY_TAX_LINE_ID
2473: ,p_ap_invoice_lines_all_rec.TAX_REGIME_CODE
2474: ,p_ap_invoice_lines_all_rec.TAX

Line 2471: ,p_ap_invoice_lines_all_rec.TRX_BUSINESS_CATEGORY

2467: ,p_ap_invoice_lines_all_rec.PRODUCT_TYPE
2468: ,p_ap_invoice_lines_all_rec.PRODUCT_CATEGORY
2469: ,p_ap_invoice_lines_all_rec.PRODUCT_FISC_CLASSIFICATION
2470: ,p_ap_invoice_lines_all_rec.USER_DEFINED_FISC_CLASS
2471: ,p_ap_invoice_lines_all_rec.TRX_BUSINESS_CATEGORY
2472: ,p_ap_invoice_lines_all_rec.SUMMARY_TAX_LINE_ID
2473: ,p_ap_invoice_lines_all_rec.TAX_REGIME_CODE
2474: ,p_ap_invoice_lines_all_rec.TAX
2475: ,p_ap_invoice_lines_all_rec.TAX_JURISDICTION_CODE

Line 2472: ,p_ap_invoice_lines_all_rec.SUMMARY_TAX_LINE_ID

2468: ,p_ap_invoice_lines_all_rec.PRODUCT_CATEGORY
2469: ,p_ap_invoice_lines_all_rec.PRODUCT_FISC_CLASSIFICATION
2470: ,p_ap_invoice_lines_all_rec.USER_DEFINED_FISC_CLASS
2471: ,p_ap_invoice_lines_all_rec.TRX_BUSINESS_CATEGORY
2472: ,p_ap_invoice_lines_all_rec.SUMMARY_TAX_LINE_ID
2473: ,p_ap_invoice_lines_all_rec.TAX_REGIME_CODE
2474: ,p_ap_invoice_lines_all_rec.TAX
2475: ,p_ap_invoice_lines_all_rec.TAX_JURISDICTION_CODE
2476: ,p_ap_invoice_lines_all_rec.TAX_STATUS_CODE

Line 2473: ,p_ap_invoice_lines_all_rec.TAX_REGIME_CODE

2469: ,p_ap_invoice_lines_all_rec.PRODUCT_FISC_CLASSIFICATION
2470: ,p_ap_invoice_lines_all_rec.USER_DEFINED_FISC_CLASS
2471: ,p_ap_invoice_lines_all_rec.TRX_BUSINESS_CATEGORY
2472: ,p_ap_invoice_lines_all_rec.SUMMARY_TAX_LINE_ID
2473: ,p_ap_invoice_lines_all_rec.TAX_REGIME_CODE
2474: ,p_ap_invoice_lines_all_rec.TAX
2475: ,p_ap_invoice_lines_all_rec.TAX_JURISDICTION_CODE
2476: ,p_ap_invoice_lines_all_rec.TAX_STATUS_CODE
2477: ,p_ap_invoice_lines_all_rec.TAX_RATE_ID

Line 2474: ,p_ap_invoice_lines_all_rec.TAX

2470: ,p_ap_invoice_lines_all_rec.USER_DEFINED_FISC_CLASS
2471: ,p_ap_invoice_lines_all_rec.TRX_BUSINESS_CATEGORY
2472: ,p_ap_invoice_lines_all_rec.SUMMARY_TAX_LINE_ID
2473: ,p_ap_invoice_lines_all_rec.TAX_REGIME_CODE
2474: ,p_ap_invoice_lines_all_rec.TAX
2475: ,p_ap_invoice_lines_all_rec.TAX_JURISDICTION_CODE
2476: ,p_ap_invoice_lines_all_rec.TAX_STATUS_CODE
2477: ,p_ap_invoice_lines_all_rec.TAX_RATE_ID
2478: ,p_ap_invoice_lines_all_rec.TAX_RATE_CODE

Line 2475: ,p_ap_invoice_lines_all_rec.TAX_JURISDICTION_CODE

2471: ,p_ap_invoice_lines_all_rec.TRX_BUSINESS_CATEGORY
2472: ,p_ap_invoice_lines_all_rec.SUMMARY_TAX_LINE_ID
2473: ,p_ap_invoice_lines_all_rec.TAX_REGIME_CODE
2474: ,p_ap_invoice_lines_all_rec.TAX
2475: ,p_ap_invoice_lines_all_rec.TAX_JURISDICTION_CODE
2476: ,p_ap_invoice_lines_all_rec.TAX_STATUS_CODE
2477: ,p_ap_invoice_lines_all_rec.TAX_RATE_ID
2478: ,p_ap_invoice_lines_all_rec.TAX_RATE_CODE
2479: ,p_ap_invoice_lines_all_rec.TAX_RATE

Line 2476: ,p_ap_invoice_lines_all_rec.TAX_STATUS_CODE

2472: ,p_ap_invoice_lines_all_rec.SUMMARY_TAX_LINE_ID
2473: ,p_ap_invoice_lines_all_rec.TAX_REGIME_CODE
2474: ,p_ap_invoice_lines_all_rec.TAX
2475: ,p_ap_invoice_lines_all_rec.TAX_JURISDICTION_CODE
2476: ,p_ap_invoice_lines_all_rec.TAX_STATUS_CODE
2477: ,p_ap_invoice_lines_all_rec.TAX_RATE_ID
2478: ,p_ap_invoice_lines_all_rec.TAX_RATE_CODE
2479: ,p_ap_invoice_lines_all_rec.TAX_RATE
2480: ,p_ap_invoice_lines_all_rec.TAX_CODE_ID

Line 2477: ,p_ap_invoice_lines_all_rec.TAX_RATE_ID

2473: ,p_ap_invoice_lines_all_rec.TAX_REGIME_CODE
2474: ,p_ap_invoice_lines_all_rec.TAX
2475: ,p_ap_invoice_lines_all_rec.TAX_JURISDICTION_CODE
2476: ,p_ap_invoice_lines_all_rec.TAX_STATUS_CODE
2477: ,p_ap_invoice_lines_all_rec.TAX_RATE_ID
2478: ,p_ap_invoice_lines_all_rec.TAX_RATE_CODE
2479: ,p_ap_invoice_lines_all_rec.TAX_RATE
2480: ,p_ap_invoice_lines_all_rec.TAX_CODE_ID
2481: ,p_ap_invoice_lines_all_rec.HISTORICAL_FLAG

Line 2478: ,p_ap_invoice_lines_all_rec.TAX_RATE_CODE

2474: ,p_ap_invoice_lines_all_rec.TAX
2475: ,p_ap_invoice_lines_all_rec.TAX_JURISDICTION_CODE
2476: ,p_ap_invoice_lines_all_rec.TAX_STATUS_CODE
2477: ,p_ap_invoice_lines_all_rec.TAX_RATE_ID
2478: ,p_ap_invoice_lines_all_rec.TAX_RATE_CODE
2479: ,p_ap_invoice_lines_all_rec.TAX_RATE
2480: ,p_ap_invoice_lines_all_rec.TAX_CODE_ID
2481: ,p_ap_invoice_lines_all_rec.HISTORICAL_FLAG
2482: ,p_ap_invoice_lines_all_rec.TAX_CLASSIFICATION_CODE

Line 2479: ,p_ap_invoice_lines_all_rec.TAX_RATE

2475: ,p_ap_invoice_lines_all_rec.TAX_JURISDICTION_CODE
2476: ,p_ap_invoice_lines_all_rec.TAX_STATUS_CODE
2477: ,p_ap_invoice_lines_all_rec.TAX_RATE_ID
2478: ,p_ap_invoice_lines_all_rec.TAX_RATE_CODE
2479: ,p_ap_invoice_lines_all_rec.TAX_RATE
2480: ,p_ap_invoice_lines_all_rec.TAX_CODE_ID
2481: ,p_ap_invoice_lines_all_rec.HISTORICAL_FLAG
2482: ,p_ap_invoice_lines_all_rec.TAX_CLASSIFICATION_CODE
2483: ,p_ap_invoice_lines_all_rec.SOURCE_APPLICATION_ID

Line 2480: ,p_ap_invoice_lines_all_rec.TAX_CODE_ID

2476: ,p_ap_invoice_lines_all_rec.TAX_STATUS_CODE
2477: ,p_ap_invoice_lines_all_rec.TAX_RATE_ID
2478: ,p_ap_invoice_lines_all_rec.TAX_RATE_CODE
2479: ,p_ap_invoice_lines_all_rec.TAX_RATE
2480: ,p_ap_invoice_lines_all_rec.TAX_CODE_ID
2481: ,p_ap_invoice_lines_all_rec.HISTORICAL_FLAG
2482: ,p_ap_invoice_lines_all_rec.TAX_CLASSIFICATION_CODE
2483: ,p_ap_invoice_lines_all_rec.SOURCE_APPLICATION_ID
2484: ,p_ap_invoice_lines_all_rec.SOURCE_EVENT_CLASS_CODE

Line 2481: ,p_ap_invoice_lines_all_rec.HISTORICAL_FLAG

2477: ,p_ap_invoice_lines_all_rec.TAX_RATE_ID
2478: ,p_ap_invoice_lines_all_rec.TAX_RATE_CODE
2479: ,p_ap_invoice_lines_all_rec.TAX_RATE
2480: ,p_ap_invoice_lines_all_rec.TAX_CODE_ID
2481: ,p_ap_invoice_lines_all_rec.HISTORICAL_FLAG
2482: ,p_ap_invoice_lines_all_rec.TAX_CLASSIFICATION_CODE
2483: ,p_ap_invoice_lines_all_rec.SOURCE_APPLICATION_ID
2484: ,p_ap_invoice_lines_all_rec.SOURCE_EVENT_CLASS_CODE
2485: ,p_ap_invoice_lines_all_rec.SOURCE_ENTITY_CODE

Line 2482: ,p_ap_invoice_lines_all_rec.TAX_CLASSIFICATION_CODE

2478: ,p_ap_invoice_lines_all_rec.TAX_RATE_CODE
2479: ,p_ap_invoice_lines_all_rec.TAX_RATE
2480: ,p_ap_invoice_lines_all_rec.TAX_CODE_ID
2481: ,p_ap_invoice_lines_all_rec.HISTORICAL_FLAG
2482: ,p_ap_invoice_lines_all_rec.TAX_CLASSIFICATION_CODE
2483: ,p_ap_invoice_lines_all_rec.SOURCE_APPLICATION_ID
2484: ,p_ap_invoice_lines_all_rec.SOURCE_EVENT_CLASS_CODE
2485: ,p_ap_invoice_lines_all_rec.SOURCE_ENTITY_CODE
2486: ,p_ap_invoice_lines_all_rec.SOURCE_TRX_ID

Line 2483: ,p_ap_invoice_lines_all_rec.SOURCE_APPLICATION_ID

2479: ,p_ap_invoice_lines_all_rec.TAX_RATE
2480: ,p_ap_invoice_lines_all_rec.TAX_CODE_ID
2481: ,p_ap_invoice_lines_all_rec.HISTORICAL_FLAG
2482: ,p_ap_invoice_lines_all_rec.TAX_CLASSIFICATION_CODE
2483: ,p_ap_invoice_lines_all_rec.SOURCE_APPLICATION_ID
2484: ,p_ap_invoice_lines_all_rec.SOURCE_EVENT_CLASS_CODE
2485: ,p_ap_invoice_lines_all_rec.SOURCE_ENTITY_CODE
2486: ,p_ap_invoice_lines_all_rec.SOURCE_TRX_ID
2487: ,p_ap_invoice_lines_all_rec.SOURCE_LINE_ID

Line 2484: ,p_ap_invoice_lines_all_rec.SOURCE_EVENT_CLASS_CODE

2480: ,p_ap_invoice_lines_all_rec.TAX_CODE_ID
2481: ,p_ap_invoice_lines_all_rec.HISTORICAL_FLAG
2482: ,p_ap_invoice_lines_all_rec.TAX_CLASSIFICATION_CODE
2483: ,p_ap_invoice_lines_all_rec.SOURCE_APPLICATION_ID
2484: ,p_ap_invoice_lines_all_rec.SOURCE_EVENT_CLASS_CODE
2485: ,p_ap_invoice_lines_all_rec.SOURCE_ENTITY_CODE
2486: ,p_ap_invoice_lines_all_rec.SOURCE_TRX_ID
2487: ,p_ap_invoice_lines_all_rec.SOURCE_LINE_ID
2488: ,p_ap_invoice_lines_all_rec.SOURCE_TRX_LEVEL_TYPE

Line 2485: ,p_ap_invoice_lines_all_rec.SOURCE_ENTITY_CODE

2481: ,p_ap_invoice_lines_all_rec.HISTORICAL_FLAG
2482: ,p_ap_invoice_lines_all_rec.TAX_CLASSIFICATION_CODE
2483: ,p_ap_invoice_lines_all_rec.SOURCE_APPLICATION_ID
2484: ,p_ap_invoice_lines_all_rec.SOURCE_EVENT_CLASS_CODE
2485: ,p_ap_invoice_lines_all_rec.SOURCE_ENTITY_CODE
2486: ,p_ap_invoice_lines_all_rec.SOURCE_TRX_ID
2487: ,p_ap_invoice_lines_all_rec.SOURCE_LINE_ID
2488: ,p_ap_invoice_lines_all_rec.SOURCE_TRX_LEVEL_TYPE
2489: ,p_ap_invoice_lines_all_rec.RETAINED_AMOUNT

Line 2486: ,p_ap_invoice_lines_all_rec.SOURCE_TRX_ID

2482: ,p_ap_invoice_lines_all_rec.TAX_CLASSIFICATION_CODE
2483: ,p_ap_invoice_lines_all_rec.SOURCE_APPLICATION_ID
2484: ,p_ap_invoice_lines_all_rec.SOURCE_EVENT_CLASS_CODE
2485: ,p_ap_invoice_lines_all_rec.SOURCE_ENTITY_CODE
2486: ,p_ap_invoice_lines_all_rec.SOURCE_TRX_ID
2487: ,p_ap_invoice_lines_all_rec.SOURCE_LINE_ID
2488: ,p_ap_invoice_lines_all_rec.SOURCE_TRX_LEVEL_TYPE
2489: ,p_ap_invoice_lines_all_rec.RETAINED_AMOUNT
2490: ,p_ap_invoice_lines_all_rec.RETAINED_AMOUNT_REMAINING

Line 2487: ,p_ap_invoice_lines_all_rec.SOURCE_LINE_ID

2483: ,p_ap_invoice_lines_all_rec.SOURCE_APPLICATION_ID
2484: ,p_ap_invoice_lines_all_rec.SOURCE_EVENT_CLASS_CODE
2485: ,p_ap_invoice_lines_all_rec.SOURCE_ENTITY_CODE
2486: ,p_ap_invoice_lines_all_rec.SOURCE_TRX_ID
2487: ,p_ap_invoice_lines_all_rec.SOURCE_LINE_ID
2488: ,p_ap_invoice_lines_all_rec.SOURCE_TRX_LEVEL_TYPE
2489: ,p_ap_invoice_lines_all_rec.RETAINED_AMOUNT
2490: ,p_ap_invoice_lines_all_rec.RETAINED_AMOUNT_REMAINING
2491: ,p_ap_invoice_lines_all_rec.RETAINED_INVOICE_ID

Line 2488: ,p_ap_invoice_lines_all_rec.SOURCE_TRX_LEVEL_TYPE

2484: ,p_ap_invoice_lines_all_rec.SOURCE_EVENT_CLASS_CODE
2485: ,p_ap_invoice_lines_all_rec.SOURCE_ENTITY_CODE
2486: ,p_ap_invoice_lines_all_rec.SOURCE_TRX_ID
2487: ,p_ap_invoice_lines_all_rec.SOURCE_LINE_ID
2488: ,p_ap_invoice_lines_all_rec.SOURCE_TRX_LEVEL_TYPE
2489: ,p_ap_invoice_lines_all_rec.RETAINED_AMOUNT
2490: ,p_ap_invoice_lines_all_rec.RETAINED_AMOUNT_REMAINING
2491: ,p_ap_invoice_lines_all_rec.RETAINED_INVOICE_ID
2492: ,p_ap_invoice_lines_all_rec.RETAINED_LINE_NUMBER

Line 2489: ,p_ap_invoice_lines_all_rec.RETAINED_AMOUNT

2485: ,p_ap_invoice_lines_all_rec.SOURCE_ENTITY_CODE
2486: ,p_ap_invoice_lines_all_rec.SOURCE_TRX_ID
2487: ,p_ap_invoice_lines_all_rec.SOURCE_LINE_ID
2488: ,p_ap_invoice_lines_all_rec.SOURCE_TRX_LEVEL_TYPE
2489: ,p_ap_invoice_lines_all_rec.RETAINED_AMOUNT
2490: ,p_ap_invoice_lines_all_rec.RETAINED_AMOUNT_REMAINING
2491: ,p_ap_invoice_lines_all_rec.RETAINED_INVOICE_ID
2492: ,p_ap_invoice_lines_all_rec.RETAINED_LINE_NUMBER
2493: ,p_ap_invoice_lines_all_rec.LINE_SELECTED_FOR_RELEASE_FLAG

Line 2490: ,p_ap_invoice_lines_all_rec.RETAINED_AMOUNT_REMAINING

2486: ,p_ap_invoice_lines_all_rec.SOURCE_TRX_ID
2487: ,p_ap_invoice_lines_all_rec.SOURCE_LINE_ID
2488: ,p_ap_invoice_lines_all_rec.SOURCE_TRX_LEVEL_TYPE
2489: ,p_ap_invoice_lines_all_rec.RETAINED_AMOUNT
2490: ,p_ap_invoice_lines_all_rec.RETAINED_AMOUNT_REMAINING
2491: ,p_ap_invoice_lines_all_rec.RETAINED_INVOICE_ID
2492: ,p_ap_invoice_lines_all_rec.RETAINED_LINE_NUMBER
2493: ,p_ap_invoice_lines_all_rec.LINE_SELECTED_FOR_RELEASE_FLAG
2494: ,p_ap_invoice_lines_all_rec.LINE_OWNER_ROLE

Line 2491: ,p_ap_invoice_lines_all_rec.RETAINED_INVOICE_ID

2487: ,p_ap_invoice_lines_all_rec.SOURCE_LINE_ID
2488: ,p_ap_invoice_lines_all_rec.SOURCE_TRX_LEVEL_TYPE
2489: ,p_ap_invoice_lines_all_rec.RETAINED_AMOUNT
2490: ,p_ap_invoice_lines_all_rec.RETAINED_AMOUNT_REMAINING
2491: ,p_ap_invoice_lines_all_rec.RETAINED_INVOICE_ID
2492: ,p_ap_invoice_lines_all_rec.RETAINED_LINE_NUMBER
2493: ,p_ap_invoice_lines_all_rec.LINE_SELECTED_FOR_RELEASE_FLAG
2494: ,p_ap_invoice_lines_all_rec.LINE_OWNER_ROLE
2495: ,p_ap_invoice_lines_all_rec.DISPUTABLE_FLAG

Line 2492: ,p_ap_invoice_lines_all_rec.RETAINED_LINE_NUMBER

2488: ,p_ap_invoice_lines_all_rec.SOURCE_TRX_LEVEL_TYPE
2489: ,p_ap_invoice_lines_all_rec.RETAINED_AMOUNT
2490: ,p_ap_invoice_lines_all_rec.RETAINED_AMOUNT_REMAINING
2491: ,p_ap_invoice_lines_all_rec.RETAINED_INVOICE_ID
2492: ,p_ap_invoice_lines_all_rec.RETAINED_LINE_NUMBER
2493: ,p_ap_invoice_lines_all_rec.LINE_SELECTED_FOR_RELEASE_FLAG
2494: ,p_ap_invoice_lines_all_rec.LINE_OWNER_ROLE
2495: ,p_ap_invoice_lines_all_rec.DISPUTABLE_FLAG
2496: ,p_ap_invoice_lines_all_rec.RCV_SHIPMENT_LINE_ID

Line 2493: ,p_ap_invoice_lines_all_rec.LINE_SELECTED_FOR_RELEASE_FLAG

2489: ,p_ap_invoice_lines_all_rec.RETAINED_AMOUNT
2490: ,p_ap_invoice_lines_all_rec.RETAINED_AMOUNT_REMAINING
2491: ,p_ap_invoice_lines_all_rec.RETAINED_INVOICE_ID
2492: ,p_ap_invoice_lines_all_rec.RETAINED_LINE_NUMBER
2493: ,p_ap_invoice_lines_all_rec.LINE_SELECTED_FOR_RELEASE_FLAG
2494: ,p_ap_invoice_lines_all_rec.LINE_OWNER_ROLE
2495: ,p_ap_invoice_lines_all_rec.DISPUTABLE_FLAG
2496: ,p_ap_invoice_lines_all_rec.RCV_SHIPMENT_LINE_ID
2497: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID

Line 2494: ,p_ap_invoice_lines_all_rec.LINE_OWNER_ROLE

2490: ,p_ap_invoice_lines_all_rec.RETAINED_AMOUNT_REMAINING
2491: ,p_ap_invoice_lines_all_rec.RETAINED_INVOICE_ID
2492: ,p_ap_invoice_lines_all_rec.RETAINED_LINE_NUMBER
2493: ,p_ap_invoice_lines_all_rec.LINE_SELECTED_FOR_RELEASE_FLAG
2494: ,p_ap_invoice_lines_all_rec.LINE_OWNER_ROLE
2495: ,p_ap_invoice_lines_all_rec.DISPUTABLE_FLAG
2496: ,p_ap_invoice_lines_all_rec.RCV_SHIPMENT_LINE_ID
2497: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID
2498: ,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER

Line 2495: ,p_ap_invoice_lines_all_rec.DISPUTABLE_FLAG

2491: ,p_ap_invoice_lines_all_rec.RETAINED_INVOICE_ID
2492: ,p_ap_invoice_lines_all_rec.RETAINED_LINE_NUMBER
2493: ,p_ap_invoice_lines_all_rec.LINE_SELECTED_FOR_RELEASE_FLAG
2494: ,p_ap_invoice_lines_all_rec.LINE_OWNER_ROLE
2495: ,p_ap_invoice_lines_all_rec.DISPUTABLE_FLAG
2496: ,p_ap_invoice_lines_all_rec.RCV_SHIPMENT_LINE_ID
2497: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID
2498: ,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER
2499: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID2

Line 2496: ,p_ap_invoice_lines_all_rec.RCV_SHIPMENT_LINE_ID

2492: ,p_ap_invoice_lines_all_rec.RETAINED_LINE_NUMBER
2493: ,p_ap_invoice_lines_all_rec.LINE_SELECTED_FOR_RELEASE_FLAG
2494: ,p_ap_invoice_lines_all_rec.LINE_OWNER_ROLE
2495: ,p_ap_invoice_lines_all_rec.DISPUTABLE_FLAG
2496: ,p_ap_invoice_lines_all_rec.RCV_SHIPMENT_LINE_ID
2497: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID
2498: ,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER
2499: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID2
2500: ,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER2

Line 2497: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID

2493: ,p_ap_invoice_lines_all_rec.LINE_SELECTED_FOR_RELEASE_FLAG
2494: ,p_ap_invoice_lines_all_rec.LINE_OWNER_ROLE
2495: ,p_ap_invoice_lines_all_rec.DISPUTABLE_FLAG
2496: ,p_ap_invoice_lines_all_rec.RCV_SHIPMENT_LINE_ID
2497: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID
2498: ,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER
2499: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID2
2500: ,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER2
2501: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID3

Line 2498: ,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER

2494: ,p_ap_invoice_lines_all_rec.LINE_OWNER_ROLE
2495: ,p_ap_invoice_lines_all_rec.DISPUTABLE_FLAG
2496: ,p_ap_invoice_lines_all_rec.RCV_SHIPMENT_LINE_ID
2497: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID
2498: ,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER
2499: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID2
2500: ,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER2
2501: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID3
2502: ,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER3

Line 2499: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID2

2495: ,p_ap_invoice_lines_all_rec.DISPUTABLE_FLAG
2496: ,p_ap_invoice_lines_all_rec.RCV_SHIPMENT_LINE_ID
2497: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID
2498: ,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER
2499: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID2
2500: ,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER2
2501: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID3
2502: ,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER3
2503: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID4

Line 2500: ,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER2

2496: ,p_ap_invoice_lines_all_rec.RCV_SHIPMENT_LINE_ID
2497: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID
2498: ,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER
2499: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID2
2500: ,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER2
2501: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID3
2502: ,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER3
2503: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID4
2504: ,p_ap_invoice_lines_all_rec.PAY_AWT_GROUP_ID

Line 2501: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID3

2497: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID
2498: ,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER
2499: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID2
2500: ,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER2
2501: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID3
2502: ,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER3
2503: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID4
2504: ,p_ap_invoice_lines_all_rec.PAY_AWT_GROUP_ID
2505: );

Line 2502: ,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER3

2498: ,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER
2499: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID2
2500: ,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER2
2501: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID3
2502: ,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER3
2503: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID4
2504: ,p_ap_invoice_lines_all_rec.PAY_AWT_GROUP_ID
2505: );
2506:

Line 2503: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID4

2499: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID2
2500: ,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER2
2501: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID3
2502: ,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER3
2503: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID4
2504: ,p_ap_invoice_lines_all_rec.PAY_AWT_GROUP_ID
2505: );
2506:
2507:

Line 2504: ,p_ap_invoice_lines_all_rec.PAY_AWT_GROUP_ID

2500: ,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER2
2501: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID3
2502: ,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER3
2503: ,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID4
2504: ,p_ap_invoice_lines_all_rec.PAY_AWT_GROUP_ID
2505: );
2506:
2507:
2508: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3055: FROM ap_invoice_lines_all

3051:
3052:
3053: CURSOR c_invoice_line IS
3054: SELECT *
3055: FROM ap_invoice_lines_all
3056: WHERE invoice_id = pn_invoice_id AND line_number = pn_invoice_line_num;
3057:
3058: CURSOR c_invoice_source IS
3059: SELECT SOURCE FROM ap_invoices_all WHERE invoice_id = pn_invoice_id;

Line 3127: r_ap_inv_line_item ap_invoice_lines_all%ROWTYPE;

3123: FROM Rcv_Shipment_Lines
3124: WHERE Shipment_Header_Id = v_shipment_header_id
3125: AND To_Organization_Id = invorg;
3126:
3127: r_ap_inv_line_item ap_invoice_lines_all%ROWTYPE;
3128: count_receipts_rec count_receipts%ROWTYPE;
3129: vend_info_rec vend_info%ROWTYPE;
3130: fetch_rcv_record_rec fetch_rcv_record%ROWTYPE;
3131: set_up_info_rec set_up_info%ROWTYPE;

Line 3371: from ap_invoice_lines_all

3367: ,'Start of function apportion_tax_4_price_cor_inv');
3368:
3369: BEGIN
3370: EXECUTE IMMEDIATE 'select /* price_correct_inv_id */, po_distribution_id, amount, quantity_invoiced
3371: from ap_invoice_lines_all
3372: where invoice_id = :inv_id
3373: and line_number = :inv_line_num'
3374: INTO cur_price_correct_inv_id, cur_po_distribution_id, cur_amount, cur_quantity_invoiced
3375: USING p_inv_id, p_invoice_line_num;

Line 3529: Update ap_invoice_lines_all

3525:
3526: procedure update_ap_inv_line(p_invoice_id number,
3527: p_invoice_line_number number) is
3528: begin
3529: Update ap_invoice_lines_all
3530: set discarded_flag = 'Y',
3531: amount = 0,
3532: last_update_date = sysdate,
3533: last_updated_by = -1

Line 3540: PROCEDURE process_discard(pr_ap_invoice_line_rec AP_INVOICE_LINES_ALL%rowtype) is

3536: and line_type_lookup_code = 'MISCELLANEOUS';
3537: end update_ap_inv_line;
3538:
3539:
3540: PROCEDURE process_discard(pr_ap_invoice_line_rec AP_INVOICE_LINES_ALL%rowtype) is
3541:
3542: Cursor c_match_tax_lines(p_invoice_id number,
3543: p_invoice_line_number number,
3544: p_po_dist_id number) is

Line 3550: from ap_invoice_lines_all la, ap_invoice_distributions_all da

3546: la.po_distribution_id,
3547: da.invoice_distribution_id,
3548: la.rcv_transaction_id,
3549: la.line_number invoice_line_number
3550: from ap_invoice_lines_all la, ap_invoice_distributions_all da
3551: where la.invoice_id = p_invoice_id
3552: and la.invoice_id = da.invoice_id
3553: and la.line_number = da.invoice_line_number
3554: and la.line_type_lookup_code = 'MISCELLANEOUS'

Line 3678: ln_invoice_id ap_invoice_lines_all.invoice_id%type;

3674:
3675: cursor c_get_source(cp_invoice_id ap_invoices_all.invoice_id%type) is
3676: select source from ap_invoices_all where invoice_id = cp_invoice_id;
3677:
3678: ln_invoice_id ap_invoice_lines_all.invoice_id%type;
3679: ln_po_dist_id ap_invoice_lines_all.po_distribution_id%type;
3680: lv_discard_flag ap_invoice_lines_all.discarded_flag%type;
3681: ln_line_number ap_invoice_lines_all.line_number%type;
3682: lv_source ap_invoices_all.source%type;

Line 3679: ln_po_dist_id ap_invoice_lines_all.po_distribution_id%type;

3675: cursor c_get_source(cp_invoice_id ap_invoices_all.invoice_id%type) is
3676: select source from ap_invoices_all where invoice_id = cp_invoice_id;
3677:
3678: ln_invoice_id ap_invoice_lines_all.invoice_id%type;
3679: ln_po_dist_id ap_invoice_lines_all.po_distribution_id%type;
3680: lv_discard_flag ap_invoice_lines_all.discarded_flag%type;
3681: ln_line_number ap_invoice_lines_all.line_number%type;
3682: lv_source ap_invoices_all.source%type;
3683: lc_inv_dist ap_invoice_distributions_all%rowtype;

Line 3680: lv_discard_flag ap_invoice_lines_all.discarded_flag%type;

3676: select source from ap_invoices_all where invoice_id = cp_invoice_id;
3677:
3678: ln_invoice_id ap_invoice_lines_all.invoice_id%type;
3679: ln_po_dist_id ap_invoice_lines_all.po_distribution_id%type;
3680: lv_discard_flag ap_invoice_lines_all.discarded_flag%type;
3681: ln_line_number ap_invoice_lines_all.line_number%type;
3682: lv_source ap_invoices_all.source%type;
3683: lc_inv_dist ap_invoice_distributions_all%rowtype;
3684: ln_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%type;

Line 3681: ln_line_number ap_invoice_lines_all.line_number%type;

3677:
3678: ln_invoice_id ap_invoice_lines_all.invoice_id%type;
3679: ln_po_dist_id ap_invoice_lines_all.po_distribution_id%type;
3680: lv_discard_flag ap_invoice_lines_all.discarded_flag%type;
3681: ln_line_number ap_invoice_lines_all.line_number%type;
3682: lv_source ap_invoices_all.source%type;
3683: lc_inv_dist ap_invoice_distributions_all%rowtype;
3684: ln_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%type;
3685:

Line 3763: --Update ap_invoice_lines_all

3759:
3760: ln_inv_dist_id := jai_ap_match_tax_proc_pkg.insert_ap_inv_dist(lc_inv_dist);
3761: End Loop;
3762:
3763: --Update ap_invoice_lines_all
3764: jai_ap_match_tax_proc_pkg.update_ap_inv_line(ident_rec.invoice_id,
3765: ident_rec.invoice_line_number);
3766: Commit;
3767: End Loop;

Line 3828: --Update ap_invoice_lines_all

3824: lc_inv_dist.program_update_date := sysdate;
3825: lc_inv_dist.quantity_invoiced := null;
3826:
3827: ln_inv_dist_id := jai_ap_match_tax_proc_pkg.insert_ap_inv_dist(lc_inv_dist);
3828: --Update ap_invoice_lines_all
3829: jai_ap_match_tax_proc_pkg.update_ap_inv_line(ins_reverse_dist_lines_ers.invoice_id,
3830: ins_reverse_dist_lines_ers.invoice_line_number);
3831: Commit;
3832: End Loop;

Line 3846: from ap_invoice_lines_all la, JAI_PO_TAXES pt

3842: p_codepath in out nocopy varchar2) is
3843: cursor c_po_tax_num(cp_invoice_id number) is
3844: select sum(nm)
3845: from (select count(1) nm
3846: from ap_invoice_lines_all la, JAI_PO_TAXES pt
3847: where la.match_type in ('ITEM_TO_PO')
3848: and la.invoice_id = cp_invoice_id
3849: and la.po_line_location_id = pt.line_location_id
3850: and la.po_header_id = pt.po_header_id

Line 3855: from ap_invoice_lines_all la, JAI_RCV_LINE_TAXES lt

3851: and la.po_line_id = pt.po_line_id
3852: and la.line_number = p_invoice_line_number
3853: union all
3854: select count(1) nm
3855: from ap_invoice_lines_all la, JAI_RCV_LINE_TAXES lt
3856: where la.match_type in ('ITEM_TO_RECEIPT')
3857: and la.invoice_id = cp_invoice_id
3858: and la.line_number = p_invoice_line_number
3859: and la.rcv_transaction_id = lt.transaction_id);

Line 3921: from ap_invoice_lines_all

3917:
3918: FUNCTION enable_match_details_menu(pn_invoice_id NUMBER) RETURN VARCHAR2 is
3919: cursor c_inv_lines_count(cn_invoice_id number) is
3920: select count(1)
3921: from ap_invoice_lines_all
3922: where invoice_id = cn_invoice_id;
3923: cursor c_invoice_type(cn_invoice_id number) is
3924: select invoice_type_lookup_code
3925: from ap_invoices_all

Line 3928: select * from ap_invoice_lines_all where invoice_id = cn_invoice_id;

3924: select invoice_type_lookup_code
3925: from ap_invoices_all
3926: where invoice_id = cn_invoice_id;
3927: cursor c_invoice_lines(cn_invoice_id number) is
3928: select * from ap_invoice_lines_all where invoice_id = cn_invoice_id;
3929:
3930: lv_enable_menu varchar2(1);
3931: lv_count number;
3932: lv_invoice_type ap_invoices_all.invoice_type_lookup_code%type;