DBA Data[Home] [Help]

APPS.JMF_SHIKYU_RPT_CUR_PVT dependencies on RCV_TRANSACTIONS

Line 892: l_transaction_id rcv_transactions.transaction_id%TYPE;

888: l_api_name CONSTANT VARCHAR2(30) := 'cuar_get_rma_so';
889: -- l_start_date DATE;
890: -- l_end_date DATE;
891: -- l_set_of_book_id NUMBER;
892: l_transaction_id rcv_transactions.transaction_id%TYPE;
893: l_rcv_line_id oe_order_lines_all.line_id%TYPE;
894: l_reference_line_id oe_order_lines_all.reference_line_id%TYPE;
895: l_org_id NUMBER;
896: l_cur_rcv_order_number oe_order_headers_all.order_number%TYPE;

Line 917: FROM rcv_transactions rcv

913: ,oel.ship_from_org_id
914: ,haotl.NAME
915: ,rcv.creation_date
916: ,rcv.transaction_id
917: FROM rcv_transactions rcv
918: ,oe_order_lines_all oel
919: ,oe_order_headers_all oeh
920: ,hr_all_organization_units_tl haotl
921: WHERE oel.org_id = lp_org_id