eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AP_STND_TAX_PROCESS dependencies on AP_INVOICE_DISTRIBUTIONS

Line 51: --| 2012/02/01 amandali code fix for bug 13617527 to avoid "ap_invoice_distributions_All.accounting date cannot be null"

47: --| 2011/05/12 Zhiwei Hou Code change for Open Interface ER bug#12537533
48: --| 2011/05/24 Xiao Lv Code change for POT, reg bug#12533434 --Added by Chong.Lei for POT code port
49: --| 2011/09/30 Zhiwei Hou Code change for Open API of POT change #13023443
50: --| 2011/12/27 amandali Code fix for 13535569 to avoid unique constraint (JA.JAI_AP_INVOICE_LINES_U2) violated error |
51: --| 2012/02/01 amandali code fix for bug 13617527 to avoid "ap_invoice_distributions_All.accounting date cannot be null"
52: --| 2012/03/04 amandali Code fix for bug 13793724 to pick the non recoverable tax lines by create mass additions concurrent
53: --| 2012/08/29 nkodakan Code fix for bug 14541702 added the 'End If' in two places.
54: --| 2012/10/10 amandali Bug:14650698
55: --| Description:0 tax lines are populated when a standalone invoice is cancelled for a vendor having default service tax category.

Line 121: , Ap_Invoice_Distributions_All aida

117: SELECT
118: aila.line_number
119: FROM
120: AP_INVOICE_LINES_ALL aila
121: , Ap_Invoice_Distributions_All aida
122: WHERE aila.INVOICE_ID = aida.invoice_id (+) --rollback to original logic
123: AND aila.line_number = aida.invoice_line_number (+) --rollback to original logic
124: AND aila.invoice_id = pn_invoice_id
125: --AND aila.line_number = pn_line_number -- Added by Jia Li for inclusive tax on 2008/01/25

Line 491: INSERT INTO AP_INVOICE_DISTRIBUTIONS_ALL

487: END IF;
488:
489: FOR i IN (pn_tax_allocation_number+1) .. pn_item_allocation_number
490: LOOP
491: INSERT INTO AP_INVOICE_DISTRIBUTIONS_ALL
492: ( accounting_date
493: , accrual_posted_flag
494: , assets_addition_flag
495: , assets_tracking_flag

Line 897: , ap_invoice_distributions_s.NEXTVAL --invoice_distribution_id

893: , mrc_receipt_conversion_rate
894: , credit_card_trx_id
895: , dist_match_type
896: , rcv_transaction_id
897: , ap_invoice_distributions_s.NEXTVAL --invoice_distribution_id
898: , parent_reversal_id
899: , tax_recoverable_flag
900: , pa_cc_ar_invoice_id
901: , pa_cc_ar_invoice_line_num

Line 981: ap_invoice_distributions_all

977: , xinv_parent_reversal_id
978: , recurring_payment_id
979: , release_inv_dist_derived_from
980: FROM
981: ap_invoice_distributions_all
982: WHERE invoice_id = pn_invoice_id
983: AND invoice_line_number = pn_invoice_line_number
984: AND line_type_lookup_code = GV_CONSTANT_MISCELLANEOUS
985: AND distribution_line_number = (select min(distribution_line_number) from ap_invoice_distributions_all where

Line 985: AND distribution_line_number = (select min(distribution_line_number) from ap_invoice_distributions_all where

981: ap_invoice_distributions_all
982: WHERE invoice_id = pn_invoice_id
983: AND invoice_line_number = pn_invoice_line_number
984: AND line_type_lookup_code = GV_CONSTANT_MISCELLANEOUS
985: AND distribution_line_number = (select min(distribution_line_number) from ap_invoice_distributions_all where
986: invoice_id = pn_invoice_id
987: AND invoice_line_number = pn_invoice_line_number); /* Bug 13617527 */
988: END LOOP; --(i IN (pn_tax_allocation_number+1) .. pn_item_allocation_number)
989:

Line 1064: ap_invoice_distributions_all

1060: END IF;
1061:
1062: DELETE
1063: FROM
1064: ap_invoice_distributions_all
1065: WHERE invoice_id = pn_invoice_id
1066: AND invoice_line_number = pn_invoice_line_number
1067: AND line_type_lookup_code = GV_CONSTANT_MISCELLANEOUS
1068: AND distribution_line_number > pn_item_allocation_number;

Line 1166: ap_invoice_distributions_all

1162: , pa_addition_flag
1163: , ASSET_BOOK_TYPE_CODE
1164: , ASSET_CATEGORY_ID
1165: FROM
1166: ap_invoice_distributions_all
1167: WHERE invoice_id = ln_invoice_id
1168: AND invoice_line_number = pn_invoice_item_ln_number;
1169:
1170: CURSOR tax_line_cur (pn_invoice_item_ln_number NUMBER)

Line 1197: ap_invoice_distributions_all

1193: IS
1194: SELECT
1195: COUNT(1)
1196: FROM
1197: ap_invoice_distributions_all
1198: WHERE invoice_id = ln_invoice_id
1199: AND invoice_line_number = pn_invoice_line_number;
1200:
1201: CURSOR get_dist_total_amount_cur

Line 1210: ap_invoice_distributions_all

1206: SELECT
1207: SUM( amount )
1208: , SUM( base_amount )
1209: FROM
1210: ap_invoice_distributions_all
1211: WHERE invoice_id = ln_invoice_id
1212: AND invoice_line_number = pn_invoice_line_number
1213: AND distribution_line_number < pn_dist_line_number;
1214:

Line 1346: ap_invoice_distributions_all

1342:
1343: --allocation tax amount according to the proportion
1344: --of item dist lines
1345: UPDATE
1346: ap_invoice_distributions_all
1347: SET
1348: amount =tax_line_rec.line_amount * ln_allocation_factor
1349: /*
1350: ROUND( tax_line_rec.line_amount *

Line 1388: ap_invoice_distributions_all

1384: , ln_dist_total_base_amount;
1385: CLOSE get_dist_total_amount_cur;
1386:
1387: UPDATE
1388: ap_invoice_distributions_all
1389: SET
1390: amount =
1391: tax_line_rec.line_amount - ln_dist_total_amount
1392: , base_amount =

Line 1415: ap_invoice_distributions_all

1411: --As only one item distribution line,tax lines are not
1412: --required to be allocated.
1413:
1414: UPDATE
1415: ap_invoice_distributions_all
1416: SET
1417: amount = tax_line_rec.line_amount
1418: , base_amount = tax_line_rec.base_amount
1419: , assets_tracking_flag = item_dist_line_rec.assets_tracking_flag

Line 1669: ap_invoice_distributions_all

1665: CURSOR item_dist_account_cur IS
1666: SELECT
1667: dist_code_combination_id
1668: FROM
1669: ap_invoice_distributions_all
1670: WHERE invoice_id = pn_invoice_id
1671: AND invoice_line_number = pn_item_line_number
1672: AND distribution_line_number =1;
1673:

Line 2619: --invoice will be deleted from ap_invoice_distributions_all

2615: END IF;--( ln_proc_level >= ln_dbg_level)
2616:
2617: --Delete all exclusive taxes lines for the specified invoice id and item line
2618: --number. If invoice line number is null, all exclusive tax lines for the
2619: --invoice will be deleted from ap_invoice_distributions_all
2620: DELETE
2621: FROM
2622: ap_invoice_distributions_all aida
2623: WHERE aida.invoice_id = ln_invoice_id

Line 2622: ap_invoice_distributions_all aida

2618: --number. If invoice line number is null, all exclusive tax lines for the
2619: --invoice will be deleted from ap_invoice_distributions_all
2620: DELETE
2621: FROM
2622: ap_invoice_distributions_all aida
2623: WHERE aida.invoice_id = ln_invoice_id
2624: AND EXISTS
2625: (
2626: SELECT

Line 2641: || '.Delete from ap_invoice_distributions_all'

2637: IF ( ln_proc_level >= ln_dbg_level)
2638: THEN
2639: FND_LOG.STRING( ln_proc_level
2640: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
2641: || '.Delete from ap_invoice_distributions_all'
2642: , SQL%ROWCOUNT||' ROWS DELETED '
2643: );
2644: END IF;
2645:

Line 2778: -- delete miscellaneous from ap_invoice_distributions_all

2774: );
2775: */
2776:
2777:
2778: -- delete miscellaneous from ap_invoice_distributions_all
2779: DELETE
2780: FROM
2781: ap_invoice_distributions_all aida
2782: WHERE aida.invoice_id = ln_invoice_id

Line 2781: ap_invoice_distributions_all aida

2777:
2778: -- delete miscellaneous from ap_invoice_distributions_all
2779: DELETE
2780: FROM
2781: ap_invoice_distributions_all aida
2782: WHERE aida.invoice_id = ln_invoice_id
2783: AND EXISTS
2784: (
2785: SELECT

Line 3133: /* changes done by abhidutt for bug 12358850. AP_INVOICE_DISTRIBUTIONS_ALL fetches no records when we directly enter Default-Distribution-Account without using distribution button for the invoice line

3129: NVL(rounding_factor,0) rounding_factor
3130: FROM jai_cmn_taxes_all
3131: WHERE tax_id = pn_tax_id;
3132:
3133: /* changes done by abhidutt for bug 12358850. AP_INVOICE_DISTRIBUTIONS_ALL fetches no records when we directly enter Default-Distribution-Account without using distribution button for the invoice line
3134: in payables invoices. Added the cursor "get_assets_tracking_flag" so that asset_tracking_flag value will be fetched from the cursor instead of fetching it from SELECT query directly */
3135:
3136: CURSOR get_assets_tracking_flag
3137: IS

Line 3139: FROM ap_invoice_distributions_all

3135:
3136: CURSOR get_assets_tracking_flag
3137: IS
3138: SELECT assets_tracking_flag
3139: FROM ap_invoice_distributions_all
3140: WHERE invoice_id = pn_invoice_id
3141: AND invoice_line_number = pn_line_number
3142: AND distribution_line_number = (select min(distribution_line_number) from ap_invoice_distributions_all
3143: where invoice_id = pn_invoice_id AND invoice_line_number = pn_line_number) ; /* Bug 13617527 */

Line 3142: AND distribution_line_number = (select min(distribution_line_number) from ap_invoice_distributions_all

3138: SELECT assets_tracking_flag
3139: FROM ap_invoice_distributions_all
3140: WHERE invoice_id = pn_invoice_id
3141: AND invoice_line_number = pn_line_number
3142: AND distribution_line_number = (select min(distribution_line_number) from ap_invoice_distributions_all
3143: where invoice_id = pn_invoice_id AND invoice_line_number = pn_line_number) ; /* Bug 13617527 */
3144:
3145: tax_rec get_tax_cur%ROWTYPE;
3146: BEGIN

Line 3177: FROM ap_invoice_distributions_all

3173: pn_tax_acct_ccid => tax_rec.tax_account_id,
3174: pv_tax_type => lv_tax_type
3175: );
3176: /* commented by abhidutt for bug 12358850 SELECT assets_tracking_flag INTO lv_assets_tracking_flag
3177: FROM ap_invoice_distributions_all
3178: WHERE invoice_id = pn_invoice_id
3179: AND invoice_line_number = pn_line_number
3180: AND distribution_line_number = 1; */
3181:

Line 3201: UPDATE ap_invoice_distributions_all

3197: ln_chargeble_acct_ccid := NULL;
3198: END IF;
3199: END IF;
3200:
3201: UPDATE ap_invoice_distributions_all
3202: SET dist_code_combination_id = ln_dist_acct_ccid
3203: --charge_applicable_to_dist_id = ln_chargeble_acct_ccid /* Bug 13793724 -commented as the charge_applicable_to_dist_id is not dependent on ccid */
3204: WHERE invoice_line_number = r_jai_cmn_document_taxes.source_doc_line_id
3205: AND invoice_id = r_jai_cmn_document_taxes.source_doc_id

Line 3206: AND distribution_line_number = (select min(distribution_line_number) from ap_invoice_distributions_all where

3202: SET dist_code_combination_id = ln_dist_acct_ccid
3203: --charge_applicable_to_dist_id = ln_chargeble_acct_ccid /* Bug 13793724 -commented as the charge_applicable_to_dist_id is not dependent on ccid */
3204: WHERE invoice_line_number = r_jai_cmn_document_taxes.source_doc_line_id
3205: AND invoice_id = r_jai_cmn_document_taxes.source_doc_id
3206: AND distribution_line_number = (select min(distribution_line_number) from ap_invoice_distributions_all where
3207: invoice_line_number = r_jai_cmn_document_taxes.source_doc_line_id
3208: AND invoice_id = r_jai_cmn_document_taxes.source_doc_id); /* Bug 13617527 */
3209:
3210: END LOOP;

Line 3368: FROM ap_invoice_distributions_all aida

3364: --Added by Qiong for bug15875609 begin
3365: AND EXISTS
3366: (
3367: SELECT 'X'
3368: FROM ap_invoice_distributions_all aida
3369: WHERE aida.invoice_id = apia.invoice_id
3370: AND aida.invoice_line_number = apia.line_number
3371: )
3372: --Added by Qiong for bug15875609 end

Line 3391: FROM ap_invoice_distributions_all aida

3387: --Added by Qiong for bug15875609 begin
3388: AND EXISTS
3389: (
3390: SELECT 'X'
3391: FROM ap_invoice_distributions_all aida
3392: WHERE aida.invoice_id = apia.invoice_id
3393: AND aida.invoice_line_number = apia.line_number
3394: ) ;
3395: --Added by Qiong for bug15875609 end

Line 4414: -- inserting into ap_invoice_distributions_all table.

4410: -- 3 18-Feb-2008 Eric Ma modified for bug#6824857
4411: -- 4 21-Nov-2008 Walton modified for bug#7202316
4412: -- 5 10-Nov-2009 Bgowrava for Bug#8975118
4413: -- Added a new variable lv_dist_class with value as 'PERMANENT' and used it for the value of distribution_class column while
4414: -- inserting into ap_invoice_distributions_all table.
4415: -- 6. 26-Nov-2009 JMEENA for bug#9098529
4416: -- Added cursor get_service_type and fetched service_type_code to
4417: -- populate in the table jai_ap_invoice_lines.
4418: -- 7. 17-Nov-2009 JMEENA for bug#9206909

Line 4676: ap_invoice_distributions_all

4672: , ASSET_BOOK_TYPE_CODE
4673: , ASSET_CATEGORY_ID
4674: ,accounting_event_id --added for bug#10044104
4675: FROM
4676: ap_invoice_distributions_all
4677: WHERE invoice_id = ln_invoice_id
4678: AND invoice_line_number = pn_line_number
4679: AND distribution_line_number = pn_distribution_line_number; /*1; Bug 13617527 */
4680:

Line 4787: from ap_invoice_distributions_all

4783: and line_number=p_invoice_line_number;
4784:
4785: cursor c_exists_ap_invoice_dist_lines (p_invoice_id number, p_invoice_line_number number, p_distribution_line_number number) is
4786: select count(*)
4787: from ap_invoice_distributions_all
4788: where invoice_id = p_invoice_id
4789: and invoice_line_number = p_invoice_line_number
4790: and distribution_line_number = p_distribution_line_number;
4791:

Line 4795: FROM ap_invoice_distributions_all

4791:
4792: --Added by Qiong for bug15875609 begin
4793: cursor c_get_min_dist is
4794: select invoice_distribution_id
4795: FROM ap_invoice_distributions_all
4796: WHERE invoice_id = pn_invoice_id
4797: AND invoice_line_number = pn_line_number
4798: AND distribution_line_number =(select min(distribution_line_number) from ap_invoice_distributions_all
4799: where invoice_id = pn_invoice_id AND invoice_line_number = pn_line_number) ;

Line 4798: AND distribution_line_number =(select min(distribution_line_number) from ap_invoice_distributions_all

4794: select invoice_distribution_id
4795: FROM ap_invoice_distributions_all
4796: WHERE invoice_id = pn_invoice_id
4797: AND invoice_line_number = pn_line_number
4798: AND distribution_line_number =(select min(distribution_line_number) from ap_invoice_distributions_all
4799: where invoice_id = pn_invoice_id AND invoice_line_number = pn_line_number) ;
4800: --Added by Qiong for bug15875609 end
4801:
4802: ln_exists number := null;

Line 4805: ap_invoice_distributions_all.assets_addition_flag%TYPE;

4801:
4802: ln_exists number := null;
4803: /* End bug-13535569 */
4804: ln_dist_asst_add_flag
4805: ap_invoice_distributions_all.assets_addition_flag%TYPE;
4806: ln_dist_asst_trck_flag
4807: ap_invoice_distributions_all.assets_tracking_flag%TYPE;
4808: ln_dist_project_id
4809: ap_invoice_distributions_all.project_id%TYPE;

Line 4807: ap_invoice_distributions_all.assets_tracking_flag%TYPE;

4803: /* End bug-13535569 */
4804: ln_dist_asst_add_flag
4805: ap_invoice_distributions_all.assets_addition_flag%TYPE;
4806: ln_dist_asst_trck_flag
4807: ap_invoice_distributions_all.assets_tracking_flag%TYPE;
4808: ln_dist_project_id
4809: ap_invoice_distributions_all.project_id%TYPE;
4810: ln_dist_task_id
4811: ap_invoice_distributions_all.task_id%TYPE;

Line 4809: ap_invoice_distributions_all.project_id%TYPE;

4805: ap_invoice_distributions_all.assets_addition_flag%TYPE;
4806: ln_dist_asst_trck_flag
4807: ap_invoice_distributions_all.assets_tracking_flag%TYPE;
4808: ln_dist_project_id
4809: ap_invoice_distributions_all.project_id%TYPE;
4810: ln_dist_task_id
4811: ap_invoice_distributions_all.task_id%TYPE;
4812: ln_dist_exp_type
4813: ap_invoice_distributions_all.expenditure_type%TYPE;

Line 4811: ap_invoice_distributions_all.task_id%TYPE;

4807: ap_invoice_distributions_all.assets_tracking_flag%TYPE;
4808: ln_dist_project_id
4809: ap_invoice_distributions_all.project_id%TYPE;
4810: ln_dist_task_id
4811: ap_invoice_distributions_all.task_id%TYPE;
4812: ln_dist_exp_type
4813: ap_invoice_distributions_all.expenditure_type%TYPE;
4814: ld_dist_exp_item_date
4815: ap_invoice_distributions_all.expenditure_item_date%TYPE;

Line 4813: ap_invoice_distributions_all.expenditure_type%TYPE;

4809: ap_invoice_distributions_all.project_id%TYPE;
4810: ln_dist_task_id
4811: ap_invoice_distributions_all.task_id%TYPE;
4812: ln_dist_exp_type
4813: ap_invoice_distributions_all.expenditure_type%TYPE;
4814: ld_dist_exp_item_date
4815: ap_invoice_distributions_all.expenditure_item_date%TYPE;
4816: ln_dist_exp_org_id
4817: ap_invoice_distributions_all.expenditure_organization_id%TYPE;

Line 4815: ap_invoice_distributions_all.expenditure_item_date%TYPE;

4811: ap_invoice_distributions_all.task_id%TYPE;
4812: ln_dist_exp_type
4813: ap_invoice_distributions_all.expenditure_type%TYPE;
4814: ld_dist_exp_item_date
4815: ap_invoice_distributions_all.expenditure_item_date%TYPE;
4816: ln_dist_exp_org_id
4817: ap_invoice_distributions_all.expenditure_organization_id%TYPE;
4818: ln_dist_pa_context
4819: ap_invoice_distributions_all.project_accounting_context%TYPE;

Line 4817: ap_invoice_distributions_all.expenditure_organization_id%TYPE;

4813: ap_invoice_distributions_all.expenditure_type%TYPE;
4814: ld_dist_exp_item_date
4815: ap_invoice_distributions_all.expenditure_item_date%TYPE;
4816: ln_dist_exp_org_id
4817: ap_invoice_distributions_all.expenditure_organization_id%TYPE;
4818: ln_dist_pa_context
4819: ap_invoice_distributions_all.project_accounting_context%TYPE;
4820: ln_dist_pa_addition_flag
4821: ap_invoice_distributions_all.pa_addition_flag%TYPE;

Line 4819: ap_invoice_distributions_all.project_accounting_context%TYPE;

4815: ap_invoice_distributions_all.expenditure_item_date%TYPE;
4816: ln_dist_exp_org_id
4817: ap_invoice_distributions_all.expenditure_organization_id%TYPE;
4818: ln_dist_pa_context
4819: ap_invoice_distributions_all.project_accounting_context%TYPE;
4820: ln_dist_pa_addition_flag
4821: ap_invoice_distributions_all.pa_addition_flag%TYPE;
4822: lv_asset_book_type_code
4823: ap_invoice_distributions_all.asset_book_type_code%TYPE;

Line 4821: ap_invoice_distributions_all.pa_addition_flag%TYPE;

4817: ap_invoice_distributions_all.expenditure_organization_id%TYPE;
4818: ln_dist_pa_context
4819: ap_invoice_distributions_all.project_accounting_context%TYPE;
4820: ln_dist_pa_addition_flag
4821: ap_invoice_distributions_all.pa_addition_flag%TYPE;
4822: lv_asset_book_type_code
4823: ap_invoice_distributions_all.asset_book_type_code%TYPE;
4824: ln_asset_category_id
4825: ap_invoice_distributions_all.asset_category_id%TYPE;

Line 4823: ap_invoice_distributions_all.asset_book_type_code%TYPE;

4819: ap_invoice_distributions_all.project_accounting_context%TYPE;
4820: ln_dist_pa_addition_flag
4821: ap_invoice_distributions_all.pa_addition_flag%TYPE;
4822: lv_asset_book_type_code
4823: ap_invoice_distributions_all.asset_book_type_code%TYPE;
4824: ln_asset_category_id
4825: ap_invoice_distributions_all.asset_category_id%TYPE;
4826: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
4827: ln_proc_level NUMBER := FND_LOG.level_procedure;

Line 4825: ap_invoice_distributions_all.asset_category_id%TYPE;

4821: ap_invoice_distributions_all.pa_addition_flag%TYPE;
4822: lv_asset_book_type_code
4823: ap_invoice_distributions_all.asset_book_type_code%TYPE;
4824: ln_asset_category_id
4825: ap_invoice_distributions_all.asset_category_id%TYPE;
4826: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
4827: ln_proc_level NUMBER := FND_LOG.level_procedure;
4828: lv_proc_name VARCHAR2 (100):= 'Create_Tax_Lines';
4829: ln_user_id NUMBER := fnd_global.user_id;

Line 4842: ap_invoicE_distributions_all

4838: cursor get_event_id(cp_invoice_id in number)
4839: is
4840: select accounting_event_id
4841: from
4842: ap_invoicE_distributions_all
4843: where line_type_lookup_code = 'ITEM'
4844: and invoice_id = cp_invoice_id
4845: AND NVL(posted_flag, 'N') = 'N';
4846: --start additions for bug#12946186

Line 4847: ln_dist_taxamt ap_invoice_distributions_all.amount%type;

4843: where line_type_lookup_code = 'ITEM'
4844: and invoice_id = cp_invoice_id
4845: AND NVL(posted_flag, 'N') = 'N';
4846: --start additions for bug#12946186
4847: ln_dist_taxamt ap_invoice_distributions_all.amount%type;
4848: ln_dist_lineno number;
4849: ln_invoice_line_amt ap_invoice_lines_all.amount%type;
4850:
4851:

Line 5117: 'INSERT INTO ap_invoice_distributions_all

5113: , :27
5114: )';
5115:
5116: lv_insert_ap_inv_dist_ln_sql :=
5117: 'INSERT INTO ap_invoice_distributions_all
5118: ( accounting_date
5119: , accrual_posted_flag
5120: , assets_addition_flag
5121: , assets_tracking_flag

Line 5756: from ap_invoice_distributions_all where invoice_id = pn_invoice_id

5752: , pn_cr_percentage =>tax_rec.mod_cr_percentage
5753: );
5754: /* start- Bug 13617527 */
5755: select min(distribution_line_number) into ln_distribution_line_number
5756: from ap_invoice_distributions_all where invoice_id = pn_invoice_id
5757: and invoice_line_number = ap_invoice_lines_rec.line_number;
5758: /* end- bug 13617527 */
5759: --get mandantory parameters from item line
5760: --the acct distribution will be handled in other procedure

Line 5982: ap_invoice_distributions_s.NEXTVAL

5978: --AAdded by Xiao for Open Interface ER bug#11683927 on 10-Feb-2011, end
5979:
5980:
5981: SELECT
5982: ap_invoice_distributions_s.NEXTVAL
5983: INTO
5984: ln_inv_dist_id
5985: FROM DUAL;
5986:

Line 5990: FROM ap_invoice_distributions_all

5986:
5987: /* Bug 13793724 -start*/
5988: /* Commented by Qiong for bug15875609
5989: select invoice_distribution_id into lv_invoice_distribution_id
5990: FROM ap_invoice_distributions_all
5991: WHERE invoice_id = pn_invoice_id
5992: AND invoice_line_number = pn_line_number
5993: AND distribution_line_number =(select min(distribution_line_number) from ap_invoice_distributions_all
5994: where invoice_id = pn_invoice_id AND invoice_line_number = pn_line_number) ;

Line 5993: AND distribution_line_number =(select min(distribution_line_number) from ap_invoice_distributions_all

5989: select invoice_distribution_id into lv_invoice_distribution_id
5990: FROM ap_invoice_distributions_all
5991: WHERE invoice_id = pn_invoice_id
5992: AND invoice_line_number = pn_line_number
5993: AND distribution_line_number =(select min(distribution_line_number) from ap_invoice_distributions_all
5994: where invoice_id = pn_invoice_id AND invoice_line_number = pn_line_number) ;
5995: */
5996: --Added by Qiong for bug15875609 begin
5997: Open c_get_min_dist;

Line 6021: FROM ap_invoice_distributions aid

6017: --start additions for bug#10044104
6018:
6019: SELECT count(*)
6020: INTO l_null_event_id
6021: FROM ap_invoice_distributions aid
6022: WHERE aid.invoice_id = ln_invoice_id
6023: AND aid.accounting_event_id is NULL;
6024:
6025: if l_null_event_id>0

Line 6263: FROM ap_invoice_distributions aid

6259: --start additions for bug#10044104
6260:
6261: SELECT count(*)
6262: INTO l_null_event_id
6263: FROM ap_invoice_distributions aid
6264: WHERE aid.invoice_id = ln_invoice_id
6265: AND aid.accounting_event_id is NULL;
6266:
6267: if l_null_event_id>0

Line 6291: ap_invoice_distributions_all

6287: /*start additions by vkaranam for bug#12946186
6288: generate the multiple distribution for the negative line*/
6289: ln_dist_lineno := null;
6290: for ap_invoice_dist_rec in (select * FROM
6291: ap_invoice_distributions_all
6292: WHERE invoice_id = ln_invoice_id
6293: AND invoice_line_number = ap_invoice_lines_rec.line_number)
6294: loop
6295: /*commented for bug#12946186

Line 6299: FROM ap_invoice_distributions_all

6295: /*commented for bug#12946186
6296: -- Fetch ccid from Item line.
6297: SELECT dist_code_combination_id
6298: INTO ln_dist_acct_ccid
6299: FROM ap_invoice_distributions_all
6300: WHERE invoice_id = ln_invoice_id
6301: AND invoice_line_number = ap_invoice_lines_rec.line_number;
6302: ----------------------------------------------------------------------------------------------
6303: -- Porting the changes by Xiao POT bug#12533434, end

Line 6311: ap_invoice_distributions_s.NEXTVAL

6307: ----------------------------------------------------------------------------------------------
6308: -- Modified by Xiao for Open Interface ER bug#11683927 on 10-Feb-2011, end
6309:
6310: SELECT
6311: ap_invoice_distributions_s.NEXTVAL
6312: INTO
6313: ln_inv_dist_id
6314: FROM DUAL;
6315: --start additions for bug#12946186

Line 6560: ap_invoice_distributions_s.NEXTVAL

6556: --------------------------------------------------------------------
6557: --Added by Xiao for Open Interface ER bug#11683927 on 10-Feb-2011, end
6558:
6559: SELECT
6560: ap_invoice_distributions_s.NEXTVAL
6561: INTO
6562: ln_inv_dist_id
6563: FROM DUAL;
6564: ln_chargeble_acct_ccid := null; /* Bug 13793724 - assets tracking flag is set to 'N' and hence setting ln_chargeble_acct_ccid to null */