APPS.JL_BR_AR_GENERATE_DEBIT_MEMO dependencies on RA_CUST_TRX_TYPES

Line 80: RA_CUST_TRX_TYPES e RA_SALESREPS AR_MEMO_LINES*/

76: FROM ra_account_default_segments
77: WHERE gl_default_id = X_gl_default_id;
78:
79: /* Get the account id to the Revene and Receivables tables
80: RA_CUST_TRX_TYPES e RA_SALESREPS AR_MEMO_LINES*/
81:
82: BEGIN
83: SELECT gl_id_rev, gl_id_rec
84: INTO X_cust_rev_id, X_cust_rec_id

Line 85: FROM ra_cust_trx_types

81:
82: BEGIN
83: SELECT gl_id_rev, gl_id_rec
84: INTO X_cust_rev_id, X_cust_rec_id
85: FROM ra_cust_trx_types
86: WHERE cust_trx_type_id = X_cust_trx_type_id;
87:
88: EXCEPTION
89: WHEN NO_DATA_FOUND THEN NULL;

Line 125: Verifica se o segmento esta' na tab. RA_CUST_TRX_TYPES entao

121:
122: X_select1 := DBMS_SQL.OPEN_CURSOR;
123:
124: /* Se o segmento nao e' uma X_constant entao
125: Verifica se o segmento esta' na tab. RA_CUST_TRX_TYPES entao
126: se o tipo de conta for Revenue Account entao
127: busca o id da conta Rev. da RA_CUST_TRX_TYPES
128: senao se o tipo de conta for Receivable Account entao
129: busca o id da conta Rec. da RA_CUST_TRX_TYPES

Line 127: busca o id da conta Rev. da RA_CUST_TRX_TYPES

123:
124: /* Se o segmento nao e' uma X_constant entao
125: Verifica se o segmento esta' na tab. RA_CUST_TRX_TYPES entao
126: se o tipo de conta for Revenue Account entao
127: busca o id da conta Rev. da RA_CUST_TRX_TYPES
128: senao se o tipo de conta for Receivable Account entao
129: busca o id da conta Rec. da RA_CUST_TRX_TYPES
130: senao verifica se segmento esta tab. RA_SALESREPS entao
131: se o tipo de conta for Revenue Account entao

Line 129: busca o id da conta Rec. da RA_CUST_TRX_TYPES

125: Verifica se o segmento esta' na tab. RA_CUST_TRX_TYPES entao
126: se o tipo de conta for Revenue Account entao
127: busca o id da conta Rev. da RA_CUST_TRX_TYPES
128: senao se o tipo de conta for Receivable Account entao
129: busca o id da conta Rec. da RA_CUST_TRX_TYPES
130: senao verifica se segmento esta tab. RA_SALESREPS entao
131: se o tipo de conta for Revenue Account entao
132: busca o id da conta Rev. da RA_SALESREPS
133: senao se o tipo de conta for Receivable Account entao

Line 137: IF X_table_name = 'RA_CUST_TRX_TYPES' THEN

133: senao se o tipo de conta for Receivable Account entao
134: busca o id da conta Rec. da RA_SALESREPS
135: */
136: IF X_constant IS NULL THEN
137: IF X_table_name = 'RA_CUST_TRX_TYPES' THEN
138: IF X_account_type = 'REV' THEN
139: X_gl_id := X_cust_rev_id;
140: ELSIF X_account_type = 'REC' THEN
141: X_gl_id := X_cust_rec_id;

Line 815: FROM ra_cust_trx_types

811:
812: /* Check if this transaction has to be posted to GL */
813: SELECT post_to_gl
814: INTO X_post_gl
815: FROM ra_cust_trx_types
816: WHERE cust_trx_type_id = X_cust_trx_type_id;
817:
818: IF X_post_gl = 'Y' THEN
819: X_gl_date := X_idm_date;