APPS.GML_RECV_TRANS_PKG dependencies on MTL_SYSTEM_ITEMS

Line 856: v_item_id mtl_system_items.inventory_item_id%TYPE;

852: v_destination_type_code rcv_transactions.transaction_type%TYPE;
853: v_transacion_id rcv_transactions.transaction_id%TYPE;
854: v_header_interface_id rcv_transactions_interface.header_interface_id%TYPE;
855:
856: v_item_id mtl_system_items.inventory_item_id%TYPE;
857: v_item_no mtl_system_items.segment1%TYPE;
858: v_item_desc mtl_system_items.description%TYPE;
859: v_subinventory mtl_secondary_inventories.secondary_inventory_name%TYPE;
860: v_transaction_type rcv_transactions.transaction_type%TYPE;

Line 857: v_item_no mtl_system_items.segment1%TYPE;

853: v_transacion_id rcv_transactions.transaction_id%TYPE;
854: v_header_interface_id rcv_transactions_interface.header_interface_id%TYPE;
855:
856: v_item_id mtl_system_items.inventory_item_id%TYPE;
857: v_item_no mtl_system_items.segment1%TYPE;
858: v_item_desc mtl_system_items.description%TYPE;
859: v_subinventory mtl_secondary_inventories.secondary_inventory_name%TYPE;
860: v_transaction_type rcv_transactions.transaction_type%TYPE;
861:

Line 858: v_item_desc mtl_system_items.description%TYPE;

854: v_header_interface_id rcv_transactions_interface.header_interface_id%TYPE;
855:
856: v_item_id mtl_system_items.inventory_item_id%TYPE;
857: v_item_no mtl_system_items.segment1%TYPE;
858: v_item_desc mtl_system_items.description%TYPE;
859: v_subinventory mtl_secondary_inventories.secondary_inventory_name%TYPE;
860: v_transaction_type rcv_transactions.transaction_type%TYPE;
861:
862: v_shipment_header_id rcv_transactions.shipment_header_id%TYPE;

Line 951: FROM mtl_system_items

947: WHERE item_id = vc_opm_item_id;
948:
949: CURSOR app_item_cur(vc_opm_item_no VARCHAR2) IS
950: SELECT inventory_item_id,description
951: FROM mtl_system_items
952: WHERE segment1 = vc_opm_item_no;
953:
954: /* Uday Phadtare B1785880 removed unit_price from select */
955: CURSOR app_po_line_cur(vc_apps_po_header_id NUMBER,

Line 976: FROM mtl_system_items

972: /* Bug #1470411*/
973: CURSOR rev_control_code_cur(vc_inventory_item_id IN NUMBER,
974: vc_ship_to_organization_id IN NUMBER) IS
975: SELECT revision_qty_control_code
976: FROM mtl_system_items
977: WHERE inventory_item_id = vc_inventory_item_id AND
978: organization_id = vc_ship_to_organization_id;
979:
980: