DBA Data[Home] [Help]

APPS.JAI_RCV_RSL_TRIGGER_PKG dependencies on MTL_SYSTEM_ITEMS

Line 38: SELECT item_type FROM mtl_system_items

34: v_ops_flag PO_LINE_TYPES_B.OUTSIDE_OPERATION_FLAG%TYPE;
35:
36: -- Commented the following cursor by Bgowrava for Bug#6144268
37: /* CURSOR c_item_type( p_organization_id IN NUMBER, p_inv_item_id IN NUMBER) IS
38: SELECT item_type FROM mtl_system_items
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;

Line 42: v_item_type MTL_SYSTEM_ITEMS.item_type%TYPE;

38: SELECT item_type FROM mtl_system_items
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