DBA Data[Home] [Help]

APPS.GML_RECV_TRANS_PKG dependencies on MTL_SECONDARY_INVENTORIES

Line 859: v_subinventory mtl_secondary_inventories.secondary_inventory_name%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;
863: v_shipment_line_id rcv_transactions.shipment_line_id%TYPE;

Line 993: FROM mtl_secondary_inventories

989:
990: /* Bug#1098066 */
991: CURSOR app_subinventory_cur(vc_ship_to_organization_id VARCHAR2) IS
992: SELECT secondary_inventory_name
993: FROM mtl_secondary_inventories
994: WHERE organization_id = vc_ship_to_organization_id AND
995: NVL(disable_date,sysdate+1) > sysdate ;
996:
997: /* Bug 1969740 */