[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OE_SCH_RSV_SET_LINES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  ONT.OE_SCH_RSV_SET_LINES_V
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, LINE_ID
, ORG_ID
, HEADER_ID
, LINE_TYPE_ID
, LINE_NUMBER
, ORDERED_ITEM
, REQUEST_DATE
, PROMISE_DATE
, SCHEDULE_ARRIVAL_DATE
, SCHEDULE_SHIP_DATE
, ORDER_QUANTITY_UOM
, PRICING_QUANTITY
, PRICING_QUANTITY_UOM
, CANCELLED_QUANTITY
, SHIPPED_QUANTITY
, ORDERED_QUANTITY
, FULFILLED_QUANTITY
, SHIPPING_QUANTITY
, SHIPPING_QUANTITY_UOM
, DELIVERY_LEAD_TIME
, AUTO_SELECTED_QUANTITY
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, CUST_PO_NUMBER
, SHIP_TOLERANCE_ABOVE
, SHIP_TOLERANCE_BELOW
, DEMAND_BUCKET_TYPE_CODE
, RLA_SCHEDULE_TYPE_CODE
, CUSTOMER_DOCK_CODE
, CUSTOMER_JOB
, CUSTOMER_PRODUCTION_LINE
, CUST_MODEL_SERIAL_NUMBER
, PROJECT_ID
, TASK_ID
, END_ITEM_UNIT_NUMBER
, SOLD_TO_ORG_ID
, SHIP_FROM_ORG_ID
, SHIP_TO_ORG_ID
, DELIVER_TO_ORG_ID
, INTMED_SHIP_TO_ORG_ID
, INVOICE_TO_ORG_ID
, SHIP_TO_CONTACT_ID
, DELIVER_TO_CONTACT_ID
, INTMED_SHIP_TO_CONTACT_ID
, INVOICE_TO_CONTACT_ID
, INVENTORY_ITEM_ID
, TAX_DATE
, TAX_CODE
, TAX_RATE
, DEMAND_CLASS_CODE
, SCHEDULE_STATUS_CODE
, SOURCE_TYPE_CODE
, PRICE_LIST_ID
, PRICING_DATE
, SHIPMENT_NUMBER
, AGREEMENT_ID
, SHIPMENT_PRIORITY_CODE
, SHIPPING_METHOD_CODE
, FREIGHT_TERMS_CODE
, FREIGHT_CARRIER_CODE
, FOB_POINT_CODE
, TAX_POINT_CODE
, PAYMENT_TERM_ID
, INVOICING_RULE_ID
, ACCOUNTING_RULE_ID
, ACCOUNTING_RULE_DURATION
, SOURCE_DOCUMENT_TYPE_ID
, ORIG_SYS_DOCUMENT_REF
, SOURCE_DOCUMENT_ID
, ORIG_SYS_LINE_REF
, SOURCE_DOCUMENT_LINE_ID
, REFERENCE_LINE_ID
, REFERENCE_TYPE
, REFERENCE_HEADER_ID
, ITEM_REVISION
, LINE_CATEGORY_CODE
, CUSTOMER_TRX_LINE_ID
, RETURN_CONTEXT
, RETURN_ATTRIBUTE1
, RETURN_ATTRIBUTE2
, RETURN_ATTRIBUTE3
, RETURN_ATTRIBUTE4
, RETURN_ATTRIBUTE5
, RETURN_ATTRIBUTE6
, RETURN_ATTRIBUTE7
, RETURN_ATTRIBUTE8
, RETURN_ATTRIBUTE9
, RETURN_ATTRIBUTE10
, RETURN_ATTRIBUTE11
, RETURN_ATTRIBUTE12
, RETURN_ATTRIBUTE13
, RETURN_ATTRIBUTE14
, RETURN_ATTRIBUTE15
, REFERENCE_CUSTOMER_TRX_LINE_ID
, UNIT_SELLING_PRICE
, UNIT_LIST_PRICE
, TAX_VALUE
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, PRICING_CONTEXT
, PRICING_ATTRIBUTE1
, PRICING_ATTRIBUTE2
, PRICING_ATTRIBUTE3
, PRICING_ATTRIBUTE4
, PRICING_ATTRIBUTE5
, PRICING_ATTRIBUTE6
, PRICING_ATTRIBUTE7
, PRICING_ATTRIBUTE8
, PRICING_ATTRIBUTE9
, PRICING_ATTRIBUTE10
, INDUSTRY_CONTEXT
, INDUSTRY_ATTRIBUTE1
, INDUSTRY_ATTRIBUTE2
, INDUSTRY_ATTRIBUTE3
, INDUSTRY_ATTRIBUTE4
, INDUSTRY_ATTRIBUTE5
, INDUSTRY_ATTRIBUTE6
, INDUSTRY_ATTRIBUTE7
, INDUSTRY_ATTRIBUTE8
, INDUSTRY_ATTRIBUTE9
, INDUSTRY_ATTRIBUTE10
, INDUSTRY_ATTRIBUTE11
, INDUSTRY_ATTRIBUTE13
, INDUSTRY_ATTRIBUTE12
, INDUSTRY_ATTRIBUTE14
, INDUSTRY_ATTRIBUTE15
, INDUSTRY_ATTRIBUTE16
, INDUSTRY_ATTRIBUTE17
, INDUSTRY_ATTRIBUTE18
, INDUSTRY_ATTRIBUTE19
, INDUSTRY_ATTRIBUTE20
, INDUSTRY_ATTRIBUTE21
, INDUSTRY_ATTRIBUTE22
, INDUSTRY_ATTRIBUTE23
, INDUSTRY_ATTRIBUTE24
, INDUSTRY_ATTRIBUTE25
, INDUSTRY_ATTRIBUTE26
, INDUSTRY_ATTRIBUTE27
, INDUSTRY_ATTRIBUTE28
, INDUSTRY_ATTRIBUTE29
, INDUSTRY_ATTRIBUTE30
, TP_CONTEXT
, TP_ATTRIBUTE1
, TP_ATTRIBUTE2
, TP_ATTRIBUTE3
, TP_ATTRIBUTE4
, TP_ATTRIBUTE5
, TP_ATTRIBUTE6
, TP_ATTRIBUTE7
, TP_ATTRIBUTE8
, TP_ATTRIBUTE9
, TP_ATTRIBUTE10
, TP_ATTRIBUTE11
, TP_ATTRIBUTE12
, TP_ATTRIBUTE13
, TP_ATTRIBUTE14
, TP_ATTRIBUTE15
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, SHIP_MODEL_COMPLETE_FLAG
, ATO_LINE_ID
, CONFIGURATION_ID
, TOP_MODEL_LINE_ID
, LINK_TO_LINE_ID
, EXPLOSION_DATE
, COMPONENT_SEQUENCE_ID
, COMPONENT_CODE
, CONFIG_DISPLAY_SEQUENCE
, SORT_ORDER
, ITEM_TYPE_CODE
, OPTION_NUMBER
, COMPONENT_NUMBER
, MODEL_GROUP_NUMBER
, OPTION_FLAG
, DEP_PLAN_REQUIRED_FLAG
, VISIBLE_DEMAND_FLAG
, ACTUAL_ARRIVAL_DATE
, ACTUAL_SHIPMENT_DATE
, EARLIEST_ACCEPTABLE_DATE
, LATEST_ACCEPTABLE_DATE
, LINE_TYPE
, SOLD_TO
, CUSTOMER_NUMBER
, SHIP_FROM
, SUBINVENTORY
, SHIP_TO
, SHIP_TO_LOCATION
, SHIP_TO_ADDRESS1
, SHIP_TO_ADDRESS2
, SHIP_TO_ADDRESS3
, SHIP_TO_ADDRESS4
, SHIP_TO_ADDRESS5
, SHIP_TO_CONTACT
, ORDER_NUMBER
, VERSION_NUMBER
, ORDER_TYPE_ID
, ORDER_TYPE
, ORDERED_DATE
, HEADER_ROW_ID
, ORDER_SOURCE_ID
, SALESREP_ID
, RETURN_REASON_CODE
, SPLIT_FROM_LINE_ID
, LINE_SET_ID
, SPLIT_BY
, CUST_PRODUCTION_SEQ_NUM
, AUTHORIZED_TO_SHIP_FLAG
, VEH_CUS_ITEM_CUM_KEY_ID
, INVOICE_INTERFACE_STATUS_CODE
, OVER_SHIP_REASON_CODE
, OVER_SHIP_RESOLVED_FLAG
, SHIP_SET_ID
, ARRIVAL_SET_ID
, ORDERED_ITEM_ID
, ITEM_IDENTIFIER_TYPE
, COMMITMENT_ID
, SHIPPING_INTERFACED_FLAG
, CREDIT_INVOICE_LINE_ID
, FIRST_ACK_CODE
, FIRST_ACK_DATE
, LAST_ACK_CODE
, LAST_ACK_DATE
, PLANNING_PRIORITY
, CONFIG_HEADER_ID
, CONFIG_REV_NBR
, BOOKED_FLAG
, CANCELLED_FLAG
, OPEN_FLAG
, SOLD_FROM_ORG_ID
, FULFILLED_FLAG
, SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS
, INVOICED_QUANTITY
, SERVICE_TXN_REASON_CODE
, SERVICE_TXN_COMMENTS
, SERVICE_DURATION
, SERVICE_PERIOD
, SERVICE_START_DATE
, SERVICE_END_DATE
, SERVICE_COTERMINATE_FLAG
, UNIT_SELLING_PERCENT
, UNIT_LIST_PERCENT
, UNIT_PERCENT_BASE_PRICE
, SERVICE_NUMBER
, SERVICE_REFERENCE_TYPE_CODE
, SERVICE_REFERENCE_LINE_ID
, SERVICE_REFERENCE_SYSTEM_ID
, FLOW_STATUS_CODE
, MODEL_REMNANT_FLAG
, FULFILLMENT_METHOD_CODE
, CALCULATE_PRICE_FLAG
, REVENUE_AMOUNT
, FULFILLMENT_DATE
, PREFERRED_GRADE
, ORDERED_QUANTITY2
, ORDERED_QUANTITY_UOM2
, SHIPPED_QUANTITY2
, CANCELLED_QUANTITY2
, SHIPPING_QUANTITY2
, SHIPPING_QUANTITY_UOM2
, FULFILLED_QUANTITY2
, UPGRADED_FLAG
, LOCK_CONTROL
, UNIT_SELLING_PRICE_PER_PQTY
, UNIT_LIST_PRICE_PER_PQTY
, CUSTOMER_LINE_NUMBER
, CUSTOMER_SHIPMENT_NUMBER
, CUSTOMER_ITEM_NET_PRICE
, CUSTOMER_PAYMENT_TERM_ID
, ORIGINAL_INVENTORY_ITEM_ID
, ORIGINAL_ITEM_IDENTIFIER_TYPE
, ORIGINAL_ORDERED_ITEM_ID
, ORIGINAL_ORDERED_ITEM
, ITEM_SUBSTITUTION_TYPE_CODE
, LATE_DEMAND_PENALTY_FACTOR
, OVERRIDE_ATP_DATE_CODE
, UNIT_COST
, MARGIN
, MARGIN_PERCENT
, USER_ITEM_DESCRIPTION
, SHIPMENT_PRIORITY
, ITEM_DESCRIPTION
, INVENTORY_ITEM
, DEMAND_CLASS
, ORDER_DATE_TYPE_CODE
, ITEM_RELATIONSHIP_TYPE
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, FIRM_DEMAND_FLAG
, EARLIEST_SHIP_DATE
, RESERVATION_SET_ID
, RESERVATION_SET_NAME
, DERIVED_QTY
, DERIVED_QTY_UOM
, CORRECTED_QTY
, PROCESS_FLAG
, DERIVED_QTY2
, CORRECTED_QTY2
FROM APPS.OE_SCH_RSV_SET_LINES_V;
APPS
AR_LOOKUPS
FND_GLOBAL
- show dependent code
HZ_CUST_ACCOUNTS
HZ_CUST_ACCOUNT_ROLES
HZ_CUST_ACCT_SITES_ALL
HZ_CUST_SITE_USES_ALL
HZ_LOCATIONS
HZ_PARTIES
HZ_PARTY_SITES
HZ_RELATIONSHIPS
MTL_PARAMETERS
MTL_SYSTEM_ITEMS_VL
OE_FND_COMMON_LOOKUPS_V
OE_LOOKUPS
OE_ORDER_HEADERS
OE_ORDER_LINES_ALL
OE_RESERVATION_SETS_V
OE_SYS_PARAMETERS
- show dependent code
OE_TRANSACTION_TYPES_TL
APPS.OE_SCH_RSV_SET_LINES_V is not referenced by any database object
|
|
|
|