APPS.AR_INVOICE_UTILS dependencies on AR_TRX_DIST_GT

Line 6712: FROM ar_trx_dist_gt

6708: x_return_status OUT NOCOPY VARCHAR2 ) IS
6709:
6710: CURSOR Cccid IS
6711: SELECT code_combination_id, trx_dist_id, trx_line_id, trx_header_id
6712: FROM ar_trx_dist_gt
6713: WHERE code_combination_id IS NOT NULL;
6714: BEGIN
6715: -- first validate the ccid, if user has passed any ccid
6716: IF pg_debug = 'Y'

Line 6785: FROM ar_trx_DIST_gt D

6781: SELECT d.trx_header_id,
6782: d.trx_line_id,
6783: D.trx_DIST_ID,
6784: arp_standard.fnd_message('AR_INAPI_CCID_NULL')
6785: FROM ar_trx_DIST_gt D
6786: WHERE code_combination_id IS NULL;
6787: -- the user can pass either amount or percent. If both amount and percent
6788: -- is passed then amount will take precendence.
6789:

Line 6800: FROM ar_trx_DIST_gt D

6796: SELECT d.trx_header_id,
6797: d.trx_line_id,
6798: D.trx_DIST_ID,
6799: arp_standard.fnd_message('AR_INAPI_AMT_PER_REQUIRED')
6800: FROM ar_trx_DIST_gt D
6801: WHERE d.PERCENT IS NULL
6802: AND d.amount IS NULL;
6803:
6804: --If accounting rule id is passed

Line 6819: FROM ar_trx_DIST_gt D,

6815: SELECT d.trx_header_id,
6816: L.trx_line_id,
6817: D.trx_DIST_ID,
6818: arp_standard.fnd_message('AR_INAPI_ONLY_PER_ALLOWED')
6819: FROM ar_trx_DIST_gt D,
6820: ar_trx_lines_GT L
6821: WHERE (L.ACCOUNTING_RULE_ID IS NOT NULL
6822: OR D.ACCOUNT_CLASS = 'REC')
6823: AND d.PERCENT IS NULL

Line 6845: FROM ar_trx_dist_gt D,

6841: SELECT d.trx_header_id,
6842: L.trx_LINE_ID,
6843: D.trx_DIST_ID,
6844: arp_standard.fnd_message('AR_INAPI_INAVLID_LINE_TYPE')
6845: FROM ar_trx_dist_gt D,
6846: ar_trx_LINES_GT L
6847: WHERE L.trx_LINE_ID = D.trx_LINE_ID
6848: AND DECODE(D.ACCOUNT_CLASS,
6849: 'TAX', 'TAX',

Line 6861: UPDATE ar_trx_dist_gt D

6857: | for account class: 'REV', 'TAX', 'FREIGHT', 'CHARGES' |
6858: | For lines w/o accounting rules. |
6859: +------------------------------------------------------------*/
6860:
6861: UPDATE ar_trx_dist_gt D
6862: SET AMOUNT =
6863: (
6864: SELECT
6865: DECODE(C.MINIMUM_ACCOUNTABLE_UNIT,

Line 6896: UPDATE ar_trx_dist_gt D

6892: | Entry form. |
6893: | For lines w/o accounting rules only. |
6894: +-----------------------------------------------------------*/
6895:
6896: UPDATE ar_trx_dist_gt D
6897: SET d.PERCENT =
6898: (
6899: SELECT DECODE(L.extended_AMOUNT,
6900: 0, 0, /* set percent =0 if line amt = 0 */

Line 6924: UPDATE ar_trx_dist_gt D

6920: | for account class: 'REV', 'TAX', 'FREIGHT', 'CHARGES' |
6921: | For lines w/o accounting rules. |
6922: +------------------------------------------------------------*/
6923:
6924: UPDATE ar_trx_dist_gt D
6925: SET ACCTD_AMOUNT =
6926: (
6927: SELECT
6928: DECODE(C.MINIMUM_ACCOUNTABLE_UNIT,

Line 6970: FROM ar_trx_DIST_gt D,

6966: SELECT l.trx_header_id,
6967: L.trx_LINE_ID,
6968: arp_standard.fnd_message('AR_INAPI_NVALID_SUM_DIST_AMT'),
6969: d.account_class || ':'||SUM(d.amount)
6970: FROM ar_trx_DIST_gt D,
6971: ar_trx_lines_GT L
6972: WHERE L.ACCOUNTING_RULE_ID IS NULL
6973: AND L.LINE_TYPE = DECODE(D.ACCOUNT_CLASS,
6974: 'REV', 'LINE',

Line 7000: FROM ar_trx_dist_gt d, ar_trx_lines_gt L, ar_trx_header_gt h

6996: SELECT d.trx_header_id,
6997: d.trx_line_ID,
6998: arp_standard.fnd_message('AR_INAPI_100_PERCENT'),
6999: sum(d.percent)
7000: FROM ar_trx_dist_gt d, ar_trx_lines_gt L, ar_trx_header_gt h
7001: WHERE d.trx_line_id = l.trx_line_id
7002: AND l.trx_header_id = h.trx_header_id
7003: GROUP BY d.trx_header_id,d.trx_line_ID, ACCOUNT_CLASS
7004: HAVING SUM(d.PERCENT) <> 100;

Line 7016: FROM ar_trx_dist_gt d

7012: invalid_value)
7013: SELECT d.trx_header_id,
7014: arp_standard.fnd_message('AR_INAPI_100_PERCENT'),
7015: sum(d.percent)
7016: FROM ar_trx_dist_gt d
7017: WHERE d.account_class = 'REC'
7018: GROUP BY d.trx_header_id
7019: HAVING SUM(d.PERCENT) <> 100;
7020:

Line 7046: UPDATE ar_trx_dist_gt dgt

7042: (NVL(PERCENT, 0) - ROUND(NVL(PERCENT,0), :pct_precision)) <> 0
7043: ); */
7044:
7045: -- update accounting set flag
7046: UPDATE ar_trx_dist_gt dgt
7047: SET dgt.account_set_flag =
7048: (SELECT DECODE(hgt.invoicing_rule_id,null,'N','Y')
7049: FROM ar_trx_header_gt hgt, ar_trx_lines_gt lgt
7050: WHERE hgt.trx_header_id = lgt.trx_header_id

Line 7060: /* UPDATE ar_trx_dist_gt D

7056: WHERE h.trx_header_id = dgt.trx_header_id
7057: AND dgt.account_class = 'REC');
7058:
7059: -- Now update the amount
7060: /* UPDATE ar_trx_dist_gt D
7061: set (amount,acctd_amount) =
7062: (Select DECODE(D.ACCOUNT_CLASS,
7063: 'REC', NULL,
7064: 'TAX', DECODE(NVL(PREV_TRX.INVOICING_RULE_ID,

Line 7183: FROM ar_trx_DIST_gt D,

7179: l_min_acc_unit) *
7180: l_min_acc_unit)),
7181: D.ACCTD_AMOUNT),
7182: NULL))
7183: FROM ar_trx_DIST_gt D,
7184: ar_trx_header_gt h
7185: --RA_CUST_TRX_TYPES TYPE,
7186: FND_CURRENCIES C,
7187: GL_SETS_OF_BOOKS G,

Line 7228: UPDATE ar_trx_dist_gt

7224: debug ('AR_INVOICE_UTILS.validate_distributions (-)' );
7225: END IF;
7226:
7227: /*4673387*/
7228: UPDATE ar_trx_dist_gt
7229: SET gl_date = NULL
7230: WHERE trx_header_id IN (SELECT trx_header_id
7231: FROM ar_trx_header_gt gt,
7232: ra_cust_trx_types ctt