DBA Data[Home] [Help]

APPS.OZF_CLAIM_SETTLEMENT_VAL_PVT dependencies on RA_CUSTOMER_TRX_LINES

Line 602: FROM ra_customer_trx_lines

598: CURSOR csr_inv_line(cv_invoice_line_id IN NUMBER) IS
599: SELECT inventory_item_id
600: , uom_code
601: , quantity_invoiced
602: FROM ra_customer_trx_lines
603: WHERE customer_trx_line_id = cv_invoice_line_id;
604:
605: CURSOR csr_inv_line_exist(cv_invoice_id IN NUMBER, cv_invoice_line_id IN NUMBER) IS
606: SELECT customer_trx_line_id

Line 607: FROM ra_customer_trx_lines

603: WHERE customer_trx_line_id = cv_invoice_line_id;
604:
605: CURSOR csr_inv_line_exist(cv_invoice_id IN NUMBER, cv_invoice_line_id IN NUMBER) IS
606: SELECT customer_trx_line_id
607: FROM ra_customer_trx_lines
608: WHERE customer_trx_id = cv_invoice_id
609: AND customer_trx_line_id = cv_invoice_line_id;
610:
611: l_claim_line_id NUMBER;

Line 637: l_inv_item_id RA_CUSTOMER_TRX_LINES.inventory_item_id%TYPE;

633: l_batch_source_id NUMBER;
634: l_payables_source VARCHAR2(30);
635: l_vendor_in_sys NUMBER;
636: l_rec_clr_in_sys NUMBER;
637: l_inv_item_id RA_CUSTOMER_TRX_LINES.inventory_item_id%TYPE;
638: l_inv_uom_code RA_CUSTOMER_TRX_LINES.uom_code%TYPE;
639: l_inv_quantity RA_CUSTOMER_TRX_LINES.quantity_invoiced%TYPE;
640: l_inv_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;
641: l_gl_date_type VARCHAR2(30);

Line 638: l_inv_uom_code RA_CUSTOMER_TRX_LINES.uom_code%TYPE;

634: l_payables_source VARCHAR2(30);
635: l_vendor_in_sys NUMBER;
636: l_rec_clr_in_sys NUMBER;
637: l_inv_item_id RA_CUSTOMER_TRX_LINES.inventory_item_id%TYPE;
638: l_inv_uom_code RA_CUSTOMER_TRX_LINES.uom_code%TYPE;
639: l_inv_quantity RA_CUSTOMER_TRX_LINES.quantity_invoiced%TYPE;
640: l_inv_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;
641: l_gl_date_type VARCHAR2(30);
642: l_line_mix_amt_sign BOOLEAN := FALSE;

Line 639: l_inv_quantity RA_CUSTOMER_TRX_LINES.quantity_invoiced%TYPE;

635: l_vendor_in_sys NUMBER;
636: l_rec_clr_in_sys NUMBER;
637: l_inv_item_id RA_CUSTOMER_TRX_LINES.inventory_item_id%TYPE;
638: l_inv_uom_code RA_CUSTOMER_TRX_LINES.uom_code%TYPE;
639: l_inv_quantity RA_CUSTOMER_TRX_LINES.quantity_invoiced%TYPE;
640: l_inv_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;
641: l_gl_date_type VARCHAR2(30);
642: l_line_mix_amt_sign BOOLEAN := FALSE;
643:

Line 640: l_inv_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;

636: l_rec_clr_in_sys NUMBER;
637: l_inv_item_id RA_CUSTOMER_TRX_LINES.inventory_item_id%TYPE;
638: l_inv_uom_code RA_CUSTOMER_TRX_LINES.uom_code%TYPE;
639: l_inv_quantity RA_CUSTOMER_TRX_LINES.quantity_invoiced%TYPE;
640: l_inv_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;
641: l_gl_date_type VARCHAR2(30);
642: l_line_mix_amt_sign BOOLEAN := FALSE;
643:
644: l_cline_sum_curr_amt NUMBER := 0;