VIEW: APPS.WMS_PACKING_MATERIAL_V

Source

View Text - Preformatted

SELECT "MOVE_ORDER_HEADER_ID","MOVE_ORDER_LINE_ID","REFERENCE","REFERENCE_ID","TXN_SOURCE_ID","DELIVERY_DETAIL_ID","ORGANIZATION_ID","ORGANIZATION_CODE","SUBINVENTORY","LOCATOR_ID","LOCATOR","PROJECT_ID","PROJECT","TASK_ID","TASK_NUMBER","TASK_NAME","INVENTORY_ITEM_ID","ITEM","ITEM_DESCRIPTION","LPN_ID","LPN","PARENT_LPN_ID","PARENT_LPN","OUTERMOST_LPN_ID","OUTERMOST_LPN","REVISION","UOM","LOT_NUMBER","QUANTITY","DELIVERY_ID","DELIVERY","DELIVERY_COMPLETED","TRIP_ID","TRIP","CARRIER_ID","CARRIER","ORDER_HEADER_ID","ORDER_NUMBER","ORDER_LINE_ID","ORDER_LINE_NUM","PACKING_INSTRUCTION","CUSTOMER_ID","CUSTOMER_NUMBER","CUSTOMER_NAME","SHIP_TO_LOCATION_ID","SHIP_TO_LOCATION","RECEIPT_NUM","DOCUMENT_TYPE","DOCUMENT_ID","DOCUMENT_NUMBER","DOCUMENT_LINE_ID","DOCUMENT_LINE_NUM","VENDOR_ID","SOURCE_ORG_ID","TRADING_PARTNER","RECEIVING_LOCATION_ID","RECEIVING_LOCATION","PTO_FLAG","SELECTED_FLAG","SHIP_SET_ID","SHIP_SET","SECONDARY_QUANTITY","SECONDARY_UOM_CODE","GRADE_CODE" from wms_packing_material_gtemp

View Text - HTML Formatted

SELECT "MOVE_ORDER_HEADER_ID"
, "MOVE_ORDER_LINE_ID"
, "REFERENCE"
, "REFERENCE_ID"
, "TXN_SOURCE_ID"
, "DELIVERY_DETAIL_ID"
, "ORGANIZATION_ID"
, "ORGANIZATION_CODE"
, "SUBINVENTORY"
, "LOCATOR_ID"
, "LOCATOR"
, "PROJECT_ID"
, "PROJECT"
, "TASK_ID"
, "TASK_NUMBER"
, "TASK_NAME"
, "INVENTORY_ITEM_ID"
, "ITEM"
, "ITEM_DESCRIPTION"
, "LPN_ID"
, "LPN"
, "PARENT_LPN_ID"
, "PARENT_LPN"
, "OUTERMOST_LPN_ID"
, "OUTERMOST_LPN"
, "REVISION"
, "UOM"
, "LOT_NUMBER"
, "QUANTITY"
, "DELIVERY_ID"
, "DELIVERY"
, "DELIVERY_COMPLETED"
, "TRIP_ID"
, "TRIP"
, "CARRIER_ID"
, "CARRIER"
, "ORDER_HEADER_ID"
, "ORDER_NUMBER"
, "ORDER_LINE_ID"
, "ORDER_LINE_NUM"
, "PACKING_INSTRUCTION"
, "CUSTOMER_ID"
, "CUSTOMER_NUMBER"
, "CUSTOMER_NAME"
, "SHIP_TO_LOCATION_ID"
, "SHIP_TO_LOCATION"
, "RECEIPT_NUM"
, "DOCUMENT_TYPE"
, "DOCUMENT_ID"
, "DOCUMENT_NUMBER"
, "DOCUMENT_LINE_ID"
, "DOCUMENT_LINE_NUM"
, "VENDOR_ID"
, "SOURCE_ORG_ID"
, "TRADING_PARTNER"
, "RECEIVING_LOCATION_ID"
, "RECEIVING_LOCATION"
, "PTO_FLAG"
, "SELECTED_FLAG"
, "SHIP_SET_ID"
, "SHIP_SET"
, "SECONDARY_QUANTITY"
, "SECONDARY_UOM_CODE"
, "GRADE_CODE"
FROM WMS_PACKING_MATERIAL_GTEMP