DBA Data[Home] [Help]

APPS.JAI_AR_TCS_REP_PKG dependencies on RCV_SHIPMENT_LINES

Line 445: FROM rcv_shipment_lines

441: WHERE transaction_id = p_transaction_id;
442:
443: CURSOR ship_rec IS
444: SELECT item_id
445: FROM rcv_shipment_lines
446: WHERE shipment_line_id = p_shipment_line_id;
447:
448: v_rcv_rec rcv_cur%ROWTYPE;
449: v_item_id rcv_shipment_lines.item_id%type;

Line 449: v_item_id rcv_shipment_lines.item_id%type;

445: FROM rcv_shipment_lines
446: WHERE shipment_line_id = p_shipment_line_id;
447:
448: v_rcv_rec rcv_cur%ROWTYPE;
449: v_item_id rcv_shipment_lines.item_id%type;
450: lv_organization_code org_organization_definitions.organization_code%type;
451: ln_set_of_books_id org_organization_definitions.set_of_books_id%type;
452: r_trx c_trx%ROWTYPE;
453: lv_account_nature VARCHAR2(30) := 'REVERSAL';