APPS.JAI_RCV_RSL_TRIGGER_PKG dependencies on RCV_TRANSACTIONS

Line 19: from RCV_TRANSACTIONS

15: --*********TRANSACTION_TYPE******************
16: CURSOR c_get_tran_type IS
17: Select transaction_type, nvl(quantity, 0) quantity
18: , routing_header_id -- Vijay Shankar for Bug#3637910
19: from RCV_TRANSACTIONS
20: where transaction_id = (
21: Select max(Transaction_id)
22: FROM RCV_TRANSACTIONS
23: where shipment_header_id = pr_new.shipment_header_id

Line 22: FROM RCV_TRANSACTIONS

18: , routing_header_id -- Vijay Shankar for Bug#3637910
19: from RCV_TRANSACTIONS
20: where transaction_id = (
21: Select max(Transaction_id)
22: FROM RCV_TRANSACTIONS
23: where shipment_header_id = pr_new.shipment_header_id
24: AND SHIPMENT_LINE_ID = pr_new.shipment_line_id
25: );
26:

Line 43: v_tran_type RCV_TRANSACTIONS.transaction_type%TYPE;

39: WHERE organization_id = p_organization_id
40: AND inventory_item_id = p_inv_item_id;*/
41:
42: v_item_type MTL_SYSTEM_ITEMS.item_type%TYPE;
43: v_tran_type RCV_TRANSACTIONS.transaction_type%TYPE;
44: v_rcv_tran_qty RCV_TRANSACTIONS.quantity%TYPE;
45:
46: -- Vijay Shankar for Bug#3637910
47: v_routing_header_id RCV_TRANSACTIONS.routing_header_id%TYPE;

Line 44: v_rcv_tran_qty RCV_TRANSACTIONS.quantity%TYPE;

40: AND inventory_item_id = p_inv_item_id;*/
41:
42: v_item_type MTL_SYSTEM_ITEMS.item_type%TYPE;
43: v_tran_type RCV_TRANSACTIONS.transaction_type%TYPE;
44: v_rcv_tran_qty RCV_TRANSACTIONS.quantity%TYPE;
45:
46: -- Vijay Shankar for Bug#3637910
47: v_routing_header_id RCV_TRANSACTIONS.routing_header_id%TYPE;
48:

Line 47: v_routing_header_id RCV_TRANSACTIONS.routing_header_id%TYPE;

43: v_tran_type RCV_TRANSACTIONS.transaction_type%TYPE;
44: v_rcv_tran_qty RCV_TRANSACTIONS.quantity%TYPE;
45:
46: -- Vijay Shankar for Bug#3637910
47: v_routing_header_id RCV_TRANSACTIONS.routing_header_id%TYPE;
48:
49: BEGIN
50: pv_return_code := jai_constants.successful ;
51: /*------------------------------------------------------------------------------------------