DBA Data[Home] [Help]

APPS.JL_ZZ_RECEIV_INTERFACE dependencies on RA_CUSTOMER_TRX_LINES

Line 354: FROM ra_customer_trx_lines

350: SELECT global_attribute2,
351: global_attribute3
352: INTO l_fsc_cls_code,
353: l_trx_cls_code
354: FROM ra_customer_trx_lines
355: WHERE customer_trx_line_id = l_invoice_line_id;
356: EXCEPTION
357: WHEN OTHERS THEN
358: l_fsc_cls_code := NULL;

Line 405: FROM ra_customer_trx_lines il

401: l_item_origin,
402: l_item_fiscal_type,
403: l_fed_trib_situation,
404: l_sta_trib_situation
405: FROM ra_customer_trx_lines il
406: WHERE il.customer_trx_line_id = l_invoice_line_id;
407:
408: EXCEPTION WHEN OTHERS THEN
409: l_op_fiscal_code := null;

Line 786: FROM ra_customer_trx_lines

782: SELECT global_attribute2,
783: global_attribute3
784: INTO l_fsc_cls_code,
785: l_trx_cls_code
786: FROM ra_customer_trx_lines
787: WHERE customer_trx_line_id = l_invoice_line_id;
788: EXCEPTION
789: WHEN OTHERS THEN
790: l_fsc_cls_code := NULL;

Line 837: FROM ra_customer_trx_lines il

833: l_item_origin,
834: l_item_fiscal_type,
835: l_fed_trib_situation,
836: l_sta_trib_situation
837: FROM ra_customer_trx_lines il
838: WHERE il.customer_trx_line_id = l_invoice_line_id;
839:
840: EXCEPTION WHEN OTHERS THEN
841: l_op_fiscal_code := null;