APPS.OZF_CLAIM_SETTLEMENT_VAL_PVT dependencies on RA_CUSTOMER_TRX_LINES

Line 563: FROM ra_customer_trx_lines

559: CURSOR csr_inv_line(cv_invoice_line_id IN NUMBER) IS
560: SELECT inventory_item_id
561: , uom_code
562: , quantity_invoiced
563: FROM ra_customer_trx_lines
564: WHERE customer_trx_line_id = cv_invoice_line_id;
565:
566: CURSOR csr_inv_line_exist(cv_invoice_id IN NUMBER, cv_invoice_line_id IN NUMBER) IS
567: SELECT customer_trx_line_id

Line 568: FROM ra_customer_trx_lines

564: WHERE customer_trx_line_id = cv_invoice_line_id;
565:
566: CURSOR csr_inv_line_exist(cv_invoice_id IN NUMBER, cv_invoice_line_id IN NUMBER) IS
567: SELECT customer_trx_line_id
568: FROM ra_customer_trx_lines
569: WHERE customer_trx_id = cv_invoice_id
570: AND customer_trx_line_id = cv_invoice_line_id;
571:
572: l_claim_line_id NUMBER;

Line 598: l_inv_item_id RA_CUSTOMER_TRX_LINES.inventory_item_id%TYPE;

594: l_batch_source_id NUMBER;
595: l_payables_source VARCHAR2(30);
596: l_vendor_in_sys NUMBER;
597: l_rec_clr_in_sys NUMBER;
598: l_inv_item_id RA_CUSTOMER_TRX_LINES.inventory_item_id%TYPE;
599: l_inv_uom_code RA_CUSTOMER_TRX_LINES.uom_code%TYPE;
600: l_inv_quantity RA_CUSTOMER_TRX_LINES.quantity_invoiced%TYPE;
601: l_inv_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;
602: l_gl_date_type VARCHAR2(30);

Line 599: l_inv_uom_code RA_CUSTOMER_TRX_LINES.uom_code%TYPE;

595: l_payables_source VARCHAR2(30);
596: l_vendor_in_sys NUMBER;
597: l_rec_clr_in_sys NUMBER;
598: l_inv_item_id RA_CUSTOMER_TRX_LINES.inventory_item_id%TYPE;
599: l_inv_uom_code RA_CUSTOMER_TRX_LINES.uom_code%TYPE;
600: l_inv_quantity RA_CUSTOMER_TRX_LINES.quantity_invoiced%TYPE;
601: l_inv_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;
602: l_gl_date_type VARCHAR2(30);
603: l_line_mix_amt_sign BOOLEAN := FALSE;

Line 600: l_inv_quantity RA_CUSTOMER_TRX_LINES.quantity_invoiced%TYPE;

596: l_vendor_in_sys NUMBER;
597: l_rec_clr_in_sys NUMBER;
598: l_inv_item_id RA_CUSTOMER_TRX_LINES.inventory_item_id%TYPE;
599: l_inv_uom_code RA_CUSTOMER_TRX_LINES.uom_code%TYPE;
600: l_inv_quantity RA_CUSTOMER_TRX_LINES.quantity_invoiced%TYPE;
601: l_inv_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;
602: l_gl_date_type VARCHAR2(30);
603: l_line_mix_amt_sign BOOLEAN := FALSE;
604:

Line 601: l_inv_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;

597: l_rec_clr_in_sys NUMBER;
598: l_inv_item_id RA_CUSTOMER_TRX_LINES.inventory_item_id%TYPE;
599: l_inv_uom_code RA_CUSTOMER_TRX_LINES.uom_code%TYPE;
600: l_inv_quantity RA_CUSTOMER_TRX_LINES.quantity_invoiced%TYPE;
601: l_inv_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;
602: l_gl_date_type VARCHAR2(30);
603: l_line_mix_amt_sign BOOLEAN := FALSE;
604:
605: -- R12: Earnings are supported for custom settlement