DBA Data[Home] [Help] [Dependency Information]


TABLE: IGC.IGC_CC_ARC_PO_LINE_LOC_ALL

Object Details
Object Name: IGC_CC_ARC_PO_LINE_LOC_ALL
Object Type: TABLE
Owner: IGC
FND Design Data: TableIGC.IGC_CC_ARC_PO_LINE_LOC_ALL
Subobject Name:
Status: VALID


IGC_CC_ARC_PO_LINE_LOC_ALL temporarily stores document shipment schedules that have been archived.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGC_CC_ARC_PO_LINE_LOC_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnLINE_LOCATION_ID
Columns
Name Datatype Length Mandatory Comments
LINE_LOCATION_ID NUMBER
Yes Document shipment schedule unique identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
PO_HEADER_ID NUMBER
Yes Document header unique identifier
PO_LINE_ID NUMBER
Yes Document line unique identifier
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
QUANTITY NUMBER

Quantity ordered or break quantity for blanket purchase
QUANTITY_RECEIVED NUMBER

Quantity received to date
QUANTITY_ACCEPTED NUMBER

Quantity accepted to date after inspection
QUANTITY_REJECTED NUMBER

Quantity rejected to date after inspection
QUANTITY_BILLED NUMBER

Quantity invoiced to date by Oracle Payables
QUANTITY_CANCELLED NUMBER

Quantity cancelled
UNIT_MEAS_LOOKUP_CODE VARCHAR2 (25)
Price break quantity unit of measure
PO_RELEASE_ID NUMBER

Release unique identifier for a release shipment
SHIP_TO_LOCATION_ID NUMBER

Unique identifier for the ship-to-location
SHIP_VIA_LOOKUP_CODE VARCHAR2 (25)
Type of carrier for the request for quote or quotation shipment
NEED_BY_DATE DATE

Need by date for the shipment schedule
PROMISED_DATE DATE

Supplier promised delivery date
LAST_ACCEPT_DATE DATE

Last acceptable receipt date for the shipment
PRICE_OVERRIDE NUMBER

Order shipment price or break price for blanket purchase orders
ENCUMBERED_FLAG VARCHAR2 (1)
Indicates whether the shipment is encumbered or not
ENCUMBERED_DATE DATE

Date of encumbrance for shipment
UNENCUMBERED_QUANTITY NUMBER

Unemcumbered quantity to date. No longer used.
FOB_LOOKUP_CODE VARCHAR2 (25)
Type of free-on-board terms for the shipment
FREIGHT_TERMS_LOOKUP_CODE VARCHAR2 (25)
Type of freight terms for the request for quote or quotation shipment
TAXABLE_FLAG VARCHAR2 (1)
Indicates whether shipment is taxable or not
TAX_NAME VARCHAR2 (15)
Tax code for shipment
ESTIMATED_TAX_AMOUNT NUMBER

Estimated tax amount for purchase order shipment. No longer used.
FROM_HEADER_ID NUMBER

Unique identifier of request for quotes used to autocreate the quotation
FROM_LINE_ID NUMBER

Unique identifier of request for quotes line used to autocreate the quotation line
FROM_LINE_LOCATION_ID NUMBER

Unique identifier of request for quotes shipment used to autocreate a quotation shipment
START_DATE DATE

Effective date of the price break. Applies to request for quotes and quotations only.
END_DATE DATE

Expiration date of the price break. Applies to request for quotes and quotations only.
LEAD_TIME NUMBER

Lead time for the price break. Applies to request for quotes and quotations only.
LEAD_TIME_UNIT VARCHAR2 (25)
Unit of measure for the lead time
PRICE_DISCOUNT NUMBER

Discount percentage for price break. Applies to request for quotes and quotations only.
TERMS_ID NUMBER

Payment terms unique identifier
APPROVED_FLAG VARCHAR2 (1)
Indicates whether shipment is approved or not
APPROVED_DATE DATE

Approval date for shipment. No longer used.
CLOSED_FLAG VARCHAR2 (1)
No longer used
CANCEL_FLAG VARCHAR2 (1)
Indicates whether shipment is cancelled or not
CANCELLED_BY NUMBER (9)
Unique identifier of employee who cancelled the shipment
CANCEL_DATE DATE

Cancellation date
CANCEL_REASON VARCHAR2 (240)
Cancellation reason provided by the employee
FIRM_STATUS_LOOKUP_CODE VARCHAR2 (25)
Indicates whether shipment is firmed or not
FIRM_DATE DATE

No longer used
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
UNIT_OF_MEASURE_CLASS VARCHAR2 (25)
Unit of measure class. No longer used.
ENCUMBER_NOW VARCHAR2 (1)
Indicates whether shipment must be inspected before the invoice is paid
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
INSPECTION_REQUIRED_FLAG VARCHAR2 (1)
Indicates whether shipment must be inspected before the invoice is paid
RECEIPT_REQUIRED_FLAG VARCHAR2 (1)
Indicates whether shipment must be received before the invoice is paid
QTY_RCV_TOLERANCE NUMBER

Maximum over-receipt tolerance percentage
QTY_RCV_EXCEPTION_CODE VARCHAR2 (25)
Describes what action is taken when the quantity received tolerance is exceeded
ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2 (25)
Describes what action is taken when the receiving location differs from the ship-to-location
ALLOW_SUBSTITUTE_RECEIPTS_FLAG VARCHAR2 (1)
Indicates whether substitute items can be received in place of the ordered items
DAYS_EARLY_RECEIPT_ALLOWED NUMBER

Maximum acceptable number of days items can be received early
DAYS_LATE_RECEIPT_ALLOWED NUMBER

Maximum acceptable number of days items can be received early
RECEIPT_DAYS_EXCEPTION_CODE VARCHAR2 (25)
Describes what action is taken when items are received earlier or later than the allowed number of days specified
INVOICE_CLOSE_TOLERANCE NUMBER

Percentage tolerance within which a shipment is automatically closed for invoice when billed
RECEIVE_CLOSE_TOLERANCE NUMBER

Percentage tolerance within which a shipment is automatically closed for receiving
SHIP_TO_ORGANIZATION_ID NUMBER

Ship-to organization unique identifier
SHIPMENT_NUM NUMBER

Shipment line number
SOURCE_SHIPMENT_ID NUMBER

Unique identifier of planned purchase order shipment that was referenced when creating this scheduled release shipment
SHIPMENT_TYPE VARCHAR2 (25) Yes Type of shipment
CLOSED_CODE VARCHAR2 (25)
Describes closure status of shipment
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
USSGL_TRANSACTION_CODE VARCHAR2 (30)
United States Standard General Ledger transaction code
GOVERNMENT_CONTEXT VARCHAR2 (30)
United States Standard General Ledger Descriptive Flexfield context column
RECEIVING_ROUTING_ID NUMBER

Receipt routing unique identifier
ACCRUE_ON_RECEIPT_FLAG VARCHAR2 (1)
Indicates whether items are accrued on receipt
CLOSED_REASON VARCHAR2 (240)
Describes why shipment is closed
CLOSED_DATE DATE

Date shipment is closed
CLOSED_BY NUMBER (9)
Unique identifier of employee who closed the shipment
ORG_ID NUMBER

Organization identifier
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
Global Descriptive Flexfield structure defining segment
QUANTITY_SHIPPED NUMBER

Quantity shipped
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (2)
Country of manufacturing for the shipment
TAX_USER_OVERRIDE_FLAG VARCHAR2 (1)
Indicator of whether somone overrode the default tax
MATCH_FLAG VARCHAR2 (1)
Match Flag
MATCH_OPTION VARCHAR2 (25)
Indicator of whether the invoice for the shipment should be matched to the purchase order or the receipt
TAX_CODE_ID NUMBER

Unique identifier for the tax code
CALCULATE_TAX_FLAG VARCHAR2 (1)
Indicator of whether tax needs to be calculated
CHANGE_PROMISED_DATE_REASON VARCHAR2 (240)
Reason for changing the promised-by date
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LINE_LOCATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      PO_HEADER_ID
,      PO_LINE_ID
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      QUANTITY
,      QUANTITY_RECEIVED
,      QUANTITY_ACCEPTED
,      QUANTITY_REJECTED
,      QUANTITY_BILLED
,      QUANTITY_CANCELLED
,      UNIT_MEAS_LOOKUP_CODE
,      PO_RELEASE_ID
,      SHIP_TO_LOCATION_ID
,      SHIP_VIA_LOOKUP_CODE
,      NEED_BY_DATE
,      PROMISED_DATE
,      LAST_ACCEPT_DATE
,      PRICE_OVERRIDE
,      ENCUMBERED_FLAG
,      ENCUMBERED_DATE
,      UNENCUMBERED_QUANTITY
,      FOB_LOOKUP_CODE
,      FREIGHT_TERMS_LOOKUP_CODE
,      TAXABLE_FLAG
,      TAX_NAME
,      ESTIMATED_TAX_AMOUNT
,      FROM_HEADER_ID
,      FROM_LINE_ID
,      FROM_LINE_LOCATION_ID
,      START_DATE
,      END_DATE
,      LEAD_TIME
,      LEAD_TIME_UNIT
,      PRICE_DISCOUNT
,      TERMS_ID
,      APPROVED_FLAG
,      APPROVED_DATE
,      CLOSED_FLAG
,      CANCEL_FLAG
,      CANCELLED_BY
,      CANCEL_DATE
,      CANCEL_REASON
,      FIRM_STATUS_LOOKUP_CODE
,      FIRM_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      UNIT_OF_MEASURE_CLASS
,      ENCUMBER_NOW
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      INSPECTION_REQUIRED_FLAG
,      RECEIPT_REQUIRED_FLAG
,      QTY_RCV_TOLERANCE
,      QTY_RCV_EXCEPTION_CODE
,      ENFORCE_SHIP_TO_LOCATION_CODE
,      ALLOW_SUBSTITUTE_RECEIPTS_FLAG
,      DAYS_EARLY_RECEIPT_ALLOWED
,      DAYS_LATE_RECEIPT_ALLOWED
,      RECEIPT_DAYS_EXCEPTION_CODE
,      INVOICE_CLOSE_TOLERANCE
,      RECEIVE_CLOSE_TOLERANCE
,      SHIP_TO_ORGANIZATION_ID
,      SHIPMENT_NUM
,      SOURCE_SHIPMENT_ID
,      SHIPMENT_TYPE
,      CLOSED_CODE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      USSGL_TRANSACTION_CODE
,      GOVERNMENT_CONTEXT
,      RECEIVING_ROUTING_ID
,      ACCRUE_ON_RECEIPT_FLAG
,      CLOSED_REASON
,      CLOSED_DATE
,      CLOSED_BY
,      ORG_ID
,      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
,      GLOBAL_ATTRIBUTE_CATEGORY
,      QUANTITY_SHIPPED
,      COUNTRY_OF_ORIGIN_CODE
,      TAX_USER_OVERRIDE_FLAG
,      MATCH_FLAG
,      MATCH_OPTION
,      TAX_CODE_ID
,      CALCULATE_TAX_FLAG
,      CHANGE_PROMISED_DATE_REASON
FROM IGC.IGC_CC_ARC_PO_LINE_LOC_ALL;

Dependencies

[top of page]

IGC.IGC_CC_ARC_PO_LINE_LOC_ALL does not reference any database object

IGC.IGC_CC_ARC_PO_LINE_LOC_ALL is referenced by following:

SchemaAPPS
SynonymIGC_CC_ARC_PO_LINE_LOC
SynonymIGC_CC_ARC_PO_LINE_LOC_ALL