VIEW: APPS.MTL_MWB_GTMP_V

Source

View Text - Preformatted

SELECT organization_code ,org_id ,item ,item_description ,item_id ,revision ,primary_uom_code ,onhand ,receiving ,inbound ,unpacked ,packed ,secondary_uom_code ,secondary_onhand ,secondary_receiving ,secondary_inbound ,secondary_unpacked ,secondary_packed ,subinventory_code ,locator ,locator_id ,lpn ,lpn_id ,lpn_context_id ,lpn_context ,cost_group ,cg_id ,loaded ,planning_party ,planning_party_id ,owning_party ,owning_party_id ,lot ,supplier_lot ,parent_lot ,serial ,grade_code ,unit_number ,lot_expiry_date ,origination_type ,origination_date ,action_code ,action_date ,retest_date ,maturity_date ,hold_date ,document_type ,document_type_id ,document_number ,document_line_number ,release_number ,po_release_id ,release_line_number ,shipment_number ,shipment_header_id_interorg ,asn ,shipment_header_id_asn ,trading_partner ,vendor_id ,trading_partner_site ,vendor_site_id ,from_org ,from_org_id ,to_org ,to_org_id ,expected_receipt_date ,shipped_date ,owning_org ,owning_org_id ,req_header_id ,oe_header_id ,po_header_id ,project_id ,project_number ,project_name ,task_id ,task_number ,task_name ,line_type ,owning_tp_type ,planning_tp_type ,owning_organization_id ,planning_organization_id ,is_pjm_enabled ,ordered_quantity ,status ,status_id ,loaded_quantity from mtl_mwb_gtmp

View Text - HTML Formatted

SELECT ORGANIZATION_CODE
, ORG_ID
, ITEM
, ITEM_DESCRIPTION
, ITEM_ID
, REVISION
, PRIMARY_UOM_CODE
, ONHAND
, RECEIVING
, INBOUND
, UNPACKED
, PACKED
, SECONDARY_UOM_CODE
, SECONDARY_ONHAND
, SECONDARY_RECEIVING
, SECONDARY_INBOUND
, SECONDARY_UNPACKED
, SECONDARY_PACKED
, SUBINVENTORY_CODE
, LOCATOR
, LOCATOR_ID
, LPN
, LPN_ID
, LPN_CONTEXT_ID
, LPN_CONTEXT
, COST_GROUP
, CG_ID
, LOADED
, PLANNING_PARTY
, PLANNING_PARTY_ID
, OWNING_PARTY
, OWNING_PARTY_ID
, LOT
, SUPPLIER_LOT
, PARENT_LOT
, SERIAL
, GRADE_CODE
, UNIT_NUMBER
, LOT_EXPIRY_DATE
, ORIGINATION_TYPE
, ORIGINATION_DATE
, ACTION_CODE
, ACTION_DATE
, RETEST_DATE
, MATURITY_DATE
, HOLD_DATE
, DOCUMENT_TYPE
, DOCUMENT_TYPE_ID
, DOCUMENT_NUMBER
, DOCUMENT_LINE_NUMBER
, RELEASE_NUMBER
, PO_RELEASE_ID
, RELEASE_LINE_NUMBER
, SHIPMENT_NUMBER
, SHIPMENT_HEADER_ID_INTERORG
, ASN
, SHIPMENT_HEADER_ID_ASN
, TRADING_PARTNER
, VENDOR_ID
, TRADING_PARTNER_SITE
, VENDOR_SITE_ID
, FROM_ORG
, FROM_ORG_ID
, TO_ORG
, TO_ORG_ID
, EXPECTED_RECEIPT_DATE
, SHIPPED_DATE
, OWNING_ORG
, OWNING_ORG_ID
, REQ_HEADER_ID
, OE_HEADER_ID
, PO_HEADER_ID
, PROJECT_ID
, PROJECT_NUMBER
, PROJECT_NAME
, TASK_ID
, TASK_NUMBER
, TASK_NAME
, LINE_TYPE
, OWNING_TP_TYPE
, PLANNING_TP_TYPE
, OWNING_ORGANIZATION_ID
, PLANNING_ORGANIZATION_ID
, IS_PJM_ENABLED
, ORDERED_QUANTITY
, STATUS
, STATUS_ID
, LOADED_QUANTITY
FROM MTL_MWB_GTMP