Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - JMF Tables and Views

TABLE - JMF.JMF_GTA_AR_DIFFERENCE_TEMP
TABLE - JMF.JMF_GTA_BATCH_NUMBERING
TABLE - JMF.JMF_GTA_DIFFERENCE_TEMP
TABLE - JMF.JMF_GTA_IMPORT_REP_TEMP
TABLE - JMF.JMF_GTA_MISSING_ARTRX_TEMP
TABLE - JMF.JMF_GTA_RULE_DFFS_ALL
TABLE - JMF.JMF_GTA_RULE_HEADERS_ALL
TABLE - JMF.JMF_GTA_RULE_TRX_TYPES_ALL
TABLE - JMF.JMF_GTA_SYSTEM_PARAMETERS_ALL
TABLE - JMF.JMF_GTA_TRANSFER_TEMP
TABLE - JMF.JMF_GTA_TRXIMP_TMP
TABLE - JMF.JMF_GTA_TRX_HEADERS_ALL
TABLE - JMF.JMF_GTA_TRX_LINES_ALL
TABLE - JMF.JMF_GTA_UNMATCHED_TEMP
TABLE - JMF.JMF_SHIKYU_ADJUSTMENTS
TABLE - JMF.JMF_SHIKYU_ALLOCATIONS
TABLE - JMF.JMF_SHIKYU_CFR_MID_TEMP
TABLE - JMF.JMF_SHIKYU_CFR_RPT_TEMP
TABLE - JMF.JMF_SHIKYU_COMPONENTS
TABLE - JMF.JMF_SHIKYU_CUR_RPT_TEMP
TABLE - JMF.JMF_SHIKYU_REPLENISHMENTS
TABLE - JMF.JMF_SHIKYU_SPR_RPT_TEMP
TABLE - JMF.JMF_SUBCONTRACT_ORDERS
TABLE - JMF.JMF_SUBCONTRACT_ORDERS_TEMP

Table: JMF_GTA_AR_DIFFERENCE_TEMP

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_TRX_ID NUMBER (15)
TRX_NUMBER VARCHAR2 (20)
TRX_DATE DATE

CUSTOMER_NAME VARCHAR2 (360)
INVOICE_CURRENCY_CODE VARCHAR2 (15)

[top of page]

JMF.JMF_GTA_AR_DIFFERENCE_TEMP does not reference any database object

JMF.JMF_GTA_AR_DIFFERENCE_TEMP is referenced by following:

APPS
SYNONYM - JMF_GTA_AR_DIFFERENCE_TEMP

[top of page]

Table: JMF_GTA_BATCH_NUMBERING

Description:
Primary Key: JMF_GTA_BATCH_NUMBERING_PK
  1. ORG_ID
Comments

TBD

Indexes
Index Type Tablespace Column
JMF_GTA_BATCH_NUMBERING_U1 UNIQUE APPS_TS_TX_IDX ORG_ID
Columns
Name Datatype Length Mandatory Comments
ORG_ID NUMBER
Y
NEXT_VALUE NUMBER
Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (22) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (22) Y
LAST_UPDATE_LOGIN NUMBER

[top of page]

JMF.JMF_GTA_BATCH_NUMBERING does not reference any database object

JMF.JMF_GTA_BATCH_NUMBERING is referenced by following:

APPS
SYNONYM - JMF_GTA_BATCH_NUMBERING

[top of page]

Table: JMF_GTA_DIFFERENCE_TEMP

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
TYPE VARCHAR2 (30)
AR_HEADER_ID NUMBER (15)
AR_LINE_ID NUMBER (15)
ATTRIBUTE VARCHAR2 (100)
AR_LINE_NUM VARCHAR2 (4000)
AR_VALUE VARCHAR2 (4000)
GTA_INVOICE_NUM VARCHAR2 (4000)
GTA_LINE_NUM VARCHAR2 (4000)
GTA_VALUE VARCHAR2 (4000)
GT_INVOICE_NUM VARCHAR2 (4000)
GT_LINE_NUM VARCHAR2 (4000)
GT_VALUE VARCHAR2 (4000)
DISCREPANCY VARCHAR2 (40)

[top of page]

JMF.JMF_GTA_DIFFERENCE_TEMP does not reference any database object

JMF.JMF_GTA_DIFFERENCE_TEMP is referenced by following:

APPS
SYNONYM - JMF_GTA_DIFFERENCE_TEMP

[top of page]

Table: JMF_GTA_IMPORT_REP_TEMP

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
SEQ NUMBER

SUCCEEDED CHAR (1)
CUSTOMER_NAME VARCHAR2 (200)
TAXPAYER_ID VARCHAR2 (30)
INVOICE_NUM VARCHAR2 (30)
INVOICE_DATE VARCHAR2 (30)
AMOUNT VARCHAR2 (30)
FAILEDREASON VARCHAR2 (1000)
STATUS VARCHAR2 (30)

[top of page]

JMF.JMF_GTA_IMPORT_REP_TEMP does not reference any database object

JMF.JMF_GTA_IMPORT_REP_TEMP is referenced by following:

APPS
SYNONYM - JMF_GTA_IMPORT_REP_TEMP

[top of page]

Table: JMF_GTA_MISSING_ARTRX_TEMP

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
RECORD_NUMBER NUMBER

GTA_TRX_NUMBER VARCHAR2 (4000)
AR_TRX_NUMBER VARCHAR2 (20)
GT_INVOICE_NUMBER VARCHAR2 (4000)
GT_INVOICE_AMOUNT VARCHAR2 (50)

[top of page]

JMF.JMF_GTA_MISSING_ARTRX_TEMP does not reference any database object

JMF.JMF_GTA_MISSING_ARTRX_TEMP is referenced by following:

APPS
SYNONYM - JMF_GTA_MISSING_ARTRX_TEMP

[top of page]

Table: JMF_GTA_RULE_DFFS_ALL

Description:
Primary Key: JMF_GTA_RULE_DFFS_ALL_PK
  1. RULE_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JMF_GTA_RULE_DFFS_ALL.RULE_HEADER_ID JMF_GTA_RULE_HEADERS_ALL
Comments

TBD

Indexes
Index Type Tablespace Column
JMF_GTA_RULE_DFFS_U1 UNIQUE APPS_TS_TX_IDX RULE_LINE_ID
JMF_GTA_RULE_DFFS_U2 UNIQUE APPS_TS_TX_IDX RULE_HEADER_ID
CONTEXT_CODE
ATTRIBUTE_COLUMN
ATTRIBUTE_VALUE
Columns
Name Datatype Length Mandatory Comments
RULE_LINE_ID NUMBER
Y
RULE_HEADER_ID NUMBER (15) Y
ORG_ID NUMBER
Y
CONDITION_RULE VARCHAR2 (1) Y
CONTEXT_CODE VARCHAR2 (30) Y
ATTRIBUTE_COLUMN VARCHAR2 (30) Y
ATTRIBUTE_VALUE VARCHAR2 (150) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (22) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (22) Y
LAST_UPDATE_LOGIN NUMBER

[top of page]

JMF.JMF_GTA_RULE_DFFS_ALL does not reference any database object

JMF.JMF_GTA_RULE_DFFS_ALL is referenced by following:

APPS
SYNONYM - JMF_GTA_RULE_DFFS
SYNONYM - JMF_GTA_RULE_DFFS_ALL

[top of page]

Table: JMF_GTA_RULE_HEADERS_ALL

Description:
Primary Key: JMF_GTA_RULE_HEADERS_ALL_PK
  1. RULE_HEADER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JMF_GTA_RULE_HEADERS_ALL.SPECIFIC_CURRENCY_CODE FND_CURRENCIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
JMF_GTA_RULE_DFFS_ALL.RULE_HEADER_ID JMF_GTA_RULE_HEADERS_ALL
JMF_GTA_RULE_TRX_TYPES_ALL.RULE_HEADER_ID JMF_GTA_RULE_HEADERS_ALL
JMF_GTA_TRX_HEADERS_ALL.RULE_HEADER_ID JMF_GTA_RULE_HEADERS_ALL
Comments

TBD

Indexes
Index Type Tablespace Column
JMF_GTA_RULE_HEADERS_U2 UNIQUE APPS_TS_TX_IDX ORG_ID
RULE_NAME
Columns
Name Datatype Length Mandatory Comments
RULE_HEADER_ID NUMBER
Y
ORG_ID NUMBER
Y
RULE_NAME VARCHAR2 (30) Y
DESCRIPTION VARCHAR2 (240)
PRIMARY_FLAG VARCHAR2 (1) Y
SALES_LIST_FLAG VARCHAR2 (1) Y
START_DATE DATE
Y
END_DATE DATE

CURRENCY_OPTION VARCHAR2 (1) Y
SPECIFIC_CURRENCY_CODE VARCHAR2 (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (22) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (22) Y
LAST_UPDATE_LOGIN NUMBER

INVOICE_TYPE VARCHAR2 (1)

[top of page]

JMF.JMF_GTA_RULE_HEADERS_ALL does not reference any database object

JMF.JMF_GTA_RULE_HEADERS_ALL is referenced by following:

APPS
SYNONYM - JMF_GTA_RULE_HEADERS
SYNONYM - JMF_GTA_RULE_HEADERS_ALL

[top of page]

Table: JMF_GTA_RULE_TRX_TYPES_ALL

Description:
Primary Key: JMF_GTA_RULE_TRX_TYPES_ALL_PK
  1. RULE_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JMF_GTA_RULE_TRX_TYPES_ALL.CUST_TRX_TYPE_ID RA_CUST_TRX_TYPES_ALL
JMF_GTA_RULE_TRX_TYPES_ALL.RULE_HEADER_ID JMF_GTA_RULE_HEADERS_ALL
Comments

TBD

Indexes
Index Type Tablespace Column
JMF_GTA_RULE_TRX_TYPES_U1 UNIQUE APPS_TS_TX_IDX RULE_LINE_ID
JMF_GTA_RULE_TRX_TYPES_U2 UNIQUE APPS_TS_TX_IDX RULE_HEADER_ID
CUST_TRX_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
RULE_LINE_ID NUMBER
Y
RULE_HEADER_ID NUMBER (15) Y
ORG_ID NUMBER
Y
CONDITION_RULE VARCHAR2 (1) Y
CUST_TRX_TYPE_ID NUMBER
Y
DESCRIPTION VARCHAR2 (240)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (22) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (22) Y
LAST_UPDATE_LOGIN NUMBER

[top of page]

JMF.JMF_GTA_RULE_TRX_TYPES_ALL does not reference any database object

JMF.JMF_GTA_RULE_TRX_TYPES_ALL is referenced by following:

APPS
SYNONYM - JMF_GTA_RULE_TRX_TYPES
SYNONYM - JMF_GTA_RULE_TRX_TYPES_ALL

[top of page]

Table: JMF_GTA_SYSTEM_PARAMETERS_ALL

Description:
Primary Key: JMF_GTA_SYSTEM_PARAMETERS_PK
  1. ORG_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JMF_GTA_SYSTEM_PARAMETERS_ALL.GT_CURRENCY_CODE FND_CURRENCIES
Comments

TBD

Indexes
Index Type Tablespace Column
JMF_GTA_SYSTEM_PARAMETERS_U1 UNIQUE APPS_TS_TX_IDX ORG_ID
Columns
Name Datatype Length Mandatory Comments
ORG_ID NUMBER
Y
AUTO_BATCH_NUMBERING_FLAG VARCHAR2 (1) Y
NEXT_BATCH_NUMBER NUMBER

VAT_TAX_TYPE_CODE VARCHAR2 (30) Y
TRX_LINE_SPLIT_FLAG VARCHAR2 (1) Y
GT_CURRENCY_CODE VARCHAR2 (15) Y
ITEM_NAME_SOURCE_FLAG VARCHAR2 (1)
CROSS_REFERENCE_TYPE VARCHAR2 (25)
MASTER_ITEM_DEFAULT_FLAG VARCHAR2 (1)
LATEST_REF_DEFAULT_FLAG VARCHAR2 (1)
RA_LINE_CONTEXT_CODE VARCHAR2 (30)
RA_MODEL_ATTRIBUTE_COLUMN VARCHAR2 (30)
RA_TAX_ATTRIBUTE_COLUMN VARCHAR2 (30)
INV_ITEM_CONTEXT_CODE VARCHAR2 (30)
INV_MODEL_ATTRIBUTE_COLUMN VARCHAR2 (30)
INV_TAX_ATTRIBUTE_COLUMN VARCHAR2 (30)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (22) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (22) Y
LAST_UPDATE_LOGIN NUMBER

[top of page]

JMF.JMF_GTA_SYSTEM_PARAMETERS_ALL does not reference any database object

JMF.JMF_GTA_SYSTEM_PARAMETERS_ALL is referenced by following:

APPS
SYNONYM - JMF_GTA_SYSTEM_PARAMETERS
SYNONYM - JMF_GTA_SYSTEM_PARAMETERS_ALL

[top of page]

Table: JMF_GTA_TRANSFER_TEMP

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
SEQ NUMBER

SUCCEEDED VARCHAR2 (1)
TRANSACTION_ID NUMBER

TRANSACTION_NUM VARCHAR2 (30)
TRANSACTION_TYPE VARCHAR2 (30)
CUSTOMER_NAME VARCHAR2 (360)
AMOUNT VARCHAR2 (30)
FAILEDREASON VARCHAR2 (2000)
GTA_INVOICE_NUM VARCHAR2 (2000)
TAX_REG_NUM VARCHAR2 (30)

[top of page]

JMF.JMF_GTA_TRANSFER_TEMP does not reference any database object

JMF.JMF_GTA_TRANSFER_TEMP is referenced by following:

APPS
SYNONYM - JMF_GTA_TRANSFER_TEMP

[top of page]

Table: JMF_GTA_TRXIMP_TMP

Description:
Primary Key: JMF_GTA_TRXIMP_TMP_PK
  1. IMPORT_SEQ
Comments
Indexes
Index Type Tablespace Column
JMF_GTA_TRXIMP_TMP_U1 UNIQUE APPS_TS_TX_IDX IMPORT_SEQ
Columns
Name Datatype Length Mandatory Comments
IMPORT_SEQ NUMBER
Y
COL1 VARCHAR2 (200)
COL2 VARCHAR2 (200)
COL3 VARCHAR2 (200)
COL4 VARCHAR2 (200)
COL5 VARCHAR2 (200)
COL6 VARCHAR2 (200)
COL7 VARCHAR2 (200)
COL8 VARCHAR2 (200)
COL9 VARCHAR2 (200)
COL10 VARCHAR2 (200)
COL11 VARCHAR2 (200)
COL12 VARCHAR2 (200)
COL13 VARCHAR2 (200)
COL14 VARCHAR2 (200)
COL15 VARCHAR2 (200)
COL16 VARCHAR2 (200)
COL17 VARCHAR2 (200)
COL18 VARCHAR2 (200)
COL19 VARCHAR2 (200)
COL20 VARCHAR2 (200)
COL21 VARCHAR2 (200)
COL22 VARCHAR2 (200)
COL23 VARCHAR2 (200)
COL24 VARCHAR2 (200)
COL25 VARCHAR2 (200)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (22) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (22) Y
LAST_UPDATE_LOGIN NUMBER

PROGRAM_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_UPDATE_DATE DATE

REQUEST_ID NUMBER

[top of page]

JMF.JMF_GTA_TRXIMP_TMP does not reference any database object

JMF.JMF_GTA_TRXIMP_TMP is referenced by following:

APPS
SYNONYM - JMF_GTA_TRXIMP_TMP

[top of page]

Table: JMF_GTA_TRX_HEADERS_ALL

Description:
Primary Key: JMF_GTA_TRX_HEADERS_ALL_PK
  1. GTA_TRX_HEADER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JMF_GTA_TRX_HEADERS_ALL.BILL_TO_CUSTOMER_ID HZ_CUST_ACCOUNTS
JMF_GTA_TRX_HEADERS_ALL.RULE_HEADER_ID JMF_GTA_RULE_HEADERS_ALL
JMF_GTA_TRX_HEADERS_ALL.RA_TRX_ID RA_CUSTOMER_TRX_ALL
JMF_GTA_TRX_HEADERS_ALL.RA_CURRENCY_CODE FND_CURRENCIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
JMF_GTA_TRX_LINES_ALL.GTA_TRX_HEADER_ID JMF_GTA_TRX_HEADERS_ALL
Comments
Indexes
Index Type Tablespace Column
JMF_GTA_TRX_HEADERS_U1 UNIQUE APPS_TS_TX_IDX GTA_TRX_HEADER_ID
JMF_GTA_TRX_HEADERS_U2 UNIQUE APPS_TS_TX_IDX GTA_TRX_NUMBER
ORG_ID
SOURCE
JMF_GTA_TRX_HEADERS_U3 UNIQUE APPS_TS_TX_IDX RA_TRX_ID
GROUP_NUMBER
VERSION
ORG_ID
SOURCE
JMF_GTA_TRX_HEADERS_N2 NONUNIQUE APPS_TS_TX_IDX REQUEST_ID
JMF_GTA_TRX_HEADERS_N3 NONUNIQUE APPS_TS_TX_IDX TRANSACTION_DATE
Columns
Name Datatype Length Mandatory Comments
RA_GL_DATE DATE
Y
RA_GL_PERIOD VARCHAR2 (15) Y
SET_OF_BOOKS_ID NUMBER (15) Y
BILL_TO_CUSTOMER_ID NUMBER (15) Y
BILL_TO_CUSTOMER_NUMBER VARCHAR2 (30)
Customer Number
BILL_TO_CUSTOMER_NAME VARCHAR2 (360)
SOURCE VARCHAR2 (3) Y
ORG_ID NUMBER (15) Y
RULE_HEADER_ID NUMBER (15) Y
GTA_TRX_HEADER_ID NUMBER (15) Y
GTA_TRX_NUMBER VARCHAR2 (30) Y
GROUP_NUMBER NUMBER (15)
VERSION NUMBER (15) Y
LATEST_VERSION_FLAG VARCHAR2 (1) Y
TRANSACTION_DATE DATE
Y
RA_TRX_ID NUMBER (15) Y
RA_TRX_NUMBER VARCHAR2 (20) Y
DESCRIPTION VARCHAR2 (240)
CUSTOMER_ADDRESS VARCHAR2 (960)
CUSTOMER_PHONE VARCHAR2 (240)
CUSTOMER_ADDRESS_PHONE VARCHAR2 (1000)
BANK_ACCOUNT_NAME VARCHAR2 (240)
BANK_ACCOUNT_NUMBER VARCHAR2 (240)
BANK_ACCOUNT_NAME_NUMBER VARCHAR2 (240)
RA_CURRENCY_CODE VARCHAR2 (15) Y
CONVERSION_TYPE VARCHAR2 (30)
CONVERSION_DATE DATE

CONVERSION_RATE NUMBER (22)
GTA_BATCH_NUMBER VARCHAR2 (30)
GT_INVOICE_NUMBER VARCHAR2 (30)
GT_INVOICE_DATE DATE

GT_INVOICE_NET_AMOUNT NUMBER

GT_INVOICE_TAX_AMOUNT NUMBER

STATUS VARCHAR2 (30) Y
SALES_LIST_FLAG VARCHAR2 (30)
CANCEL_FLAG VARCHAR2 (30)
GT_INVOICE_TYPE VARCHAR2 (1)
GT_INVOICE_CLASS VARCHAR2 (10)
GT_TAX_MONTH NUMBER

ISSUER_NAME VARCHAR2 (30)
REVIEWER_NAME VARCHAR2 (30)
PAYEE_NAME VARCHAR2 (30)
TAX_CODE VARCHAR2 (30)
TAX_RATE NUMBER

GENERATOR_ID NUMBER (15)
EXPORT_REQUEST_ID NUMBER (15)
LEGAL_ENTITY_ID NUMBER (15) Y
FP_TAX_REGISTRATION_NUMBER VARCHAR2 (50) Y
TP_TAX_REGISTRATION_NUMBER VARCHAR2 (50)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (22) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (22) Y
LAST_UPDATE_LOGIN NUMBER

PROGRAM_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_UPDATE_DATE DATE

REQUEST_ID NUMBER

INVOICE_TYPE VARCHAR2 (1)

[top of page]

JMF.JMF_GTA_TRX_HEADERS_ALL does not reference any database object

JMF.JMF_GTA_TRX_HEADERS_ALL is referenced by following:

APPS
SYNONYM - JMF_GTA_TRX_HEADERS
SYNONYM - JMF_GTA_TRX_HEADERS_ALL

[top of page]

Table: JMF_GTA_TRX_LINES_ALL

Description:
Primary Key: JMF_GTA_TRX_LINES_ALL_PK
  1. GTA_TRX_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JMF_GTA_TRX_LINES_ALL.GTA_TRX_HEADER_ID JMF_GTA_TRX_HEADERS_ALL
JMF_GTA_TRX_LINES_ALL.AR_TRX_LINE_ID RA_CUSTOMER_TRX_LINES_ALL
Comments
Indexes
Index Type Tablespace Column
JMF_GTA_TRX_LINES_U1 UNIQUE APPS_TS_TX_IDX GTA_TRX_LINE_ID
JMF_GTA_TRX_LINES_U2 UNIQUE APPS_TS_TX_IDX GTA_TRX_HEADER_ID
LINE_NUMBER
Columns
Name Datatype Length Mandatory Comments
ORG_ID NUMBER (15) Y
GTA_TRX_HEADER_ID NUMBER (15) Y
GTA_TRX_LINE_ID NUMBER (15) Y
MATCHED_FLAG VARCHAR2 (1)
LINE_NUMBER VARCHAR2 (30) Y
AR_TRX_LINE_ID NUMBER (15)
INVENTORY_ITEM_ID NUMBER (15)
ITEM_NUMBER VARCHAR2 (40)
ITEM_DESCRIPTION VARCHAR2 (240) Y
ITEM_MODEL VARCHAR2 (240)
ITEM_TAX_DENOMINATION VARCHAR2 (240) Y
TAX_RATE NUMBER
Y
UOM VARCHAR2 (3)
UOM_NAME VARCHAR2 (30)
QUANTITY NUMBER

PRICE_FLAG VARCHAR2 (1)
UNIT_PRICE NUMBER

UNIT_TAX_PRICE NUMBER

AMOUNT NUMBER

ORIGINAL_CURRENCY_AMOUNT NUMBER

TAX_AMOUNT NUMBER

DISCOUNT_FLAG VARCHAR2 (1)
ENABLED_FLAG VARCHAR2 (1)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (22) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (22) Y
LAST_UPDATE_LOGIN NUMBER

PROGRAM_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_UPDATE_DATE DATE

REQUEST_ID NUMBER

[top of page]

JMF.JMF_GTA_TRX_LINES_ALL does not reference any database object

JMF.JMF_GTA_TRX_LINES_ALL is referenced by following:

APPS
SYNONYM - JMF_GTA_TRX_LINES
SYNONYM - JMF_GTA_TRX_LINES_ALL

[top of page]

Table: JMF_GTA_UNMATCHED_TEMP

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
SOURCE VARCHAR2 (30)
AR_HEADER_ID NUMBER (15)
INVOICE_NUMBER VARCHAR2 (30)
LINE_NUMBER VARCHAR2 (30)
ITEM_NAME VARCHAR2 (300)
MODEL VARCHAR2 (300)
UNIT_PRICE NUMBER

QUANTITY NUMBER

UOM VARCHAR2 (30)
LINE_AMOUNT NUMBER

TAX_RATE NUMBER

VAT_LINE_TAX NUMBER

TP_TAX_REGISTRATION_NUMBER VARCHAR2 (50)

[top of page]

JMF.JMF_GTA_UNMATCHED_TEMP does not reference any database object

JMF.JMF_GTA_UNMATCHED_TEMP is referenced by following:

APPS
SYNONYM - JMF_GTA_UNMATCHED_TEMP

[top of page]

Table: JMF_SHIKYU_ADJUSTMENTS

Description:
Primary Key: JMF_SHIKYU_ADJUSTMENTS_PK
  1. ADJUSTMENT_ID
Comments

JMF_SHIKYU_ADJUSTMENTS stores adjustment data to be processed by the consumption adjustment concurrent program.

Indexes
Index Type Tablespace Column
JMF_SHIKYU_ADJUSTMENTS_U1 UNIQUE APPS_TS_TX_IDX ADJUSTMENT_ID
JMF_SHIKYU_ADJUSTMENTS_N1 NONUNIQUE APPS_TS_TX_IDX SUBCONTRACT_PO_SHIPMENT_ID
SHIKYU_COMPONENT_ID
Columns
Name Datatype Length Mandatory Comments
ADJUSTMENT_ID NUMBER
Y Sequence generated unique identifier of the component consumption adjustment
SUBCONTRACT_PO_SHIPMENT_ID NUMBER
Y Unique identifier of the subcontracting order shipment for which the replenishment was created
SHIKYU_COMPONENT_ID NUMBER
Y Item ID of the Subcontracting component
ADJUSTMENT NUMBER

Consumption adjustment amount
UOM VARCHAR2 (3)
Unit of Measure (UOM) of the Subcontracting component
REASON VARCHAR2 (200)
Reason for the adjustment
REQUEST_ID NUMBER

The request ID of the concurrent request running the adjustment concurrent program.
BATCH_ID NUMBER

ID to group records to be processed in batches
LAST_UPDATE_DATE DATE

Standard Who column - date when this record was last updated
LAST_UPDATED_BY NUMBER

Standard Who column - the user who last updated this record (References FND_USERS.user_id)
CREATION_DATE DATE

Standard Who column - date when this record was created
CREATED_BY NUMBER

Standard Who column - the user who created this record. (References FND_USERS.user_id)
LAST_UPDATE_LOGIN NUMBER

Standard Who column - identifies sign-on audit information of the user who last updated this record. (References FND_LOGINS.login_id)
PROGRAM_ID NUMBER

Standard Who column - the concurrent program that created or updated this record (References FND_CONCURRENT_PROGRAMS.concurrent_program_id)
PROGRAM_UPDATE_DATE DATE

Standard Who column - the date when this record was created or updated
PROGRAM_APPLICATION_ID NUMBER

Standard Who column: the application that owns the concurrent program that created or updated this record

[top of page]

JMF.JMF_SHIKYU_ADJUSTMENTS does not reference any database object

JMF.JMF_SHIKYU_ADJUSTMENTS is referenced by following:

APPS
SYNONYM - JMF_SHIKYU_ADJUSTMENTS

[top of page]

Table: JMF_SHIKYU_ALLOCATIONS

Description:
Primary Key: JMF_SHIKYU_ALLOCATIONS_PK
  1. SUBCONTRACT_PO_SHIPMENT_ID
  2. SHIKYU_COMPONENT_ID
  3. REPLENISHMENT_SO_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JMF_SHIKYU_ALLOCATIONS.REPLENISHMENT_SO_LINE_ID %
Comments

JMF_SHIKYU_ALLOCATIONS stores the allocations created between the replenishment sales orders and subcontracting order shipments for fulfilling component requirements.

Indexes
Index Type Tablespace Column
JMF_SHIKYU_ALLOCATIONS_U1 UNIQUE APPS_TS_TX_IDX SUBCONTRACT_PO_SHIPMENT_ID
SHIKYU_COMPONENT_ID
REPLENISHMENT_SO_LINE_ID
JMF_SHIKYU_ALLOCATIONS_N2 NONUNIQUE APPS_TS_TX_IDX REPLENISHMENT_SO_LINE_ID
Columns
Name Datatype Length Mandatory Comments
SUBCONTRACT_PO_SHIPMENT_ID NUMBER
Y Unique identifier of the subcontracting order shipment to which the components were allocated to.
SHIKYU_COMPONENT_ID NUMBER
Y Inventory Item ID of the Subcontracting Component
REPLENISHMENT_SO_LINE_ID NUMBER
Y Unique identifier of the replenishment sales order line
ALLOCATED_QUANTITY NUMBER

Quantity allocated for the subcontracting order component requirement
UOM VARCHAR2 (3)
Allocations Unit of Measure(UOM)
REQUEST_ID NUMBER

Standard Who column: the concurrent request that created or updated this record.
LAST_UPDATE_DATE DATE

Standard Who column: date when this record was last updated
LAST_UPDATED_BY NUMBER

Standard Who column: the user who last updated this record
CREATION_DATE DATE

Standard Who column: date when this record was created
CREATED_BY NUMBER

Standard Who column: the user who created this record
LAST_UPDATE_LOGIN NUMBER

Standard Who column: identifies sign-on audit information of the user who last updated this record
PROGRAM_ID NUMBER

Standard Who column: the concurrent program that created or updated this record
PROGRAM_UPDATE_DATE DATE

Standard Who column: the date when this record was created or updated by a concurrent program
PROGRAM_APPLICATION_ID NUMBER

Standard Who column: the application that owns the concurrent program that created or updated this record

[top of page]

JMF.JMF_SHIKYU_ALLOCATIONS does not reference any database object

JMF.JMF_SHIKYU_ALLOCATIONS is referenced by following:

APPS
SYNONYM - JMF_SHIKYU_ALLOCATIONS

[top of page]

Table: JMF_SHIKYU_CFR_MID_TEMP

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
ROW_TYPE NUMBER
Y
SHIKYU_ID NUMBER

TP_INV_ORG_ID NUMBER

ITEM_ID NUMBER

UOM VARCHAR2 (25)
QUANTITY NUMBER

PRIMARY_UOM VARCHAR2 (25)
PRIMARY_UNALLOCATED_QUANTITY NUMBER

PRIMARY_UNCONSUMED_QUANTITY NUMBER

PROJECT_ID NUMBER

TASK_ID NUMBER

OEM_INV_ORG_ID NUMBER

SUPPLIER_ID NUMBER

SITE_ID NUMBER

OU_ID NUMBER

GET_RCV_FLAG VARCHAR2 (1)
GET_REP_FLAG VARCHAR2 (1)

[top of page]

JMF.JMF_SHIKYU_CFR_MID_TEMP does not reference any database object

JMF.JMF_SHIKYU_CFR_MID_TEMP is referenced by following:

APPS
SYNONYM - JMF_SHIKYU_CFR_MID_TEMP

[top of page]

Table: JMF_SHIKYU_CFR_RPT_TEMP

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
RPT_MODE VARCHAR2 (30)
OU_ID NUMBER

OU_NAME VARCHAR2 (240)
RPT_DATA_TYPE NUMBER

TRANSACTION_ID NUMBER

OEM_INV_ORG_ID NUMBER

OEM_INV_ORG_CODE VARCHAR2 (3)
OEM_INV_ORG_NAME VARCHAR2 (240)
OEM_INV_ORG_ADDRESS VARCHAR2 (240)
SUPPLIER_ID NUMBER

SUPPLIER_NAME VARCHAR2 (50)
SITE_ADDRESS VARCHAR2 (240)
SITE_ID NUMBER

SITE_CODE VARCHAR2 (15)
CONTACT_ID NUMBER

CONTACT_NAME VARCHAR2 (50)
TP_INV_ORG_ID NUMBER

TP_INV_ORG_CODE VARCHAR2 (3)
ITEM_ID NUMBER

ITEM_NUMBER VARCHAR2 (40)
ITEM_DESCRIPTION VARCHAR2 (240)
REPLENISHMENT_TYPE VARCHAR2 (80)
CURRENCY_CODE VARCHAR2 (3)
SHIKYU_PRICE NUMBER

PROJECT_ID NUMBER

PROJECT_NUM VARCHAR2 (50)
TASK_ID NUMBER

TASK_NUM VARCHAR2 (50)
UOM VARCHAR2 (25)
ESTIMATED_QTY NUMBER

PRIMARY_UOM VARCHAR2 (25)
ITEM_COST NUMBER

FUNCTIONAL_CURRENCY VARCHAR2 (15)
REP_SO_HEADER_ID NUMBER

REP_SO_NUMBER NUMBER

REP_SO_VERSION_NUMBER NUMBER

REP_SO_LINE_ID NUMBER

REP_SO_LINE NUMBER

SHIPPED_DATE DATE

EXPECTED_RCV_DATE DATE

REP_PO_HEADER_ID NUMBER

REP_PO_NUMBER VARCHAR2 (20)
REP_PO_REVISION_NUM NUMBER

REP_PO_RELEASE_ID NUMBER

REP_PO_RELEASE_NUM NUMBER

REP_PO_LINE_ID NUMBER

REP_PO_LINE NUMBER

REP_PO_LINE_LOCATION_ID NUMBER

REP_PO_SHIPMENT NUMBER

REP_PO_DISTRIBUTION_ID NUMBER

SUBPO_COL_NO NUMBER

SUBPO_HEADER_ID NUMBER

SUBPO_NUMBER VARCHAR2 (20)
SUBPO_LINE_ID NUMBER

SUBPO_LINE_NUM NUMBER

SUBPO_RELEASE_ID NUMBER

SUBPO_RELEASE_NUM NUMBER

SUBPO_SHIPMENT_ID NUMBER

SUBPO_SHIPMENT_NUM NUMBER

OSA_ITEM_ID NUMBER

OSA_ITEM_NUMBER VARCHAR2 (40)
OSA_ITEM_DESCRIPTION VARCHAR2 (240)
REQUESTED_COMP_QTY NUMBER

ISSUED_COMP_QTY NUMBER

VALUE1 NUMBER

VALUE2 NUMBER

VALUE3 NUMBER

VALUE4 NUMBER

VALUE5 NUMBER

VALUE6 NUMBER

VALUE7 NUMBER

VALUE8 NUMBER

VALUE9 NUMBER

VALUE10 NUMBER

ATTRIBUTE1 VARCHAR2 (80)
ATTRIBUTE2 VARCHAR2 (80)
ATTRIBUTE3 VARCHAR2 (80)
ATTRIBUTE4 VARCHAR2 (80)
ATTRIBUTE5 VARCHAR2 (80)
ATTRIBUTE6 VARCHAR2 (80)
ATTRIBUTE7 VARCHAR2 (80)
ATTRIBUTE8 VARCHAR2 (80)
ATTRIBUTE9 VARCHAR2 (80)
ATTRIBUTE10 VARCHAR2 (240)
ATTRIBUTE11 VARCHAR2 (240)
ATTRIBUTE12 VARCHAR2 (240)
ATTRIBUTE13 VARCHAR2 (240)
ATTRIBUTE14 VARCHAR2 (240)
ATTRIBUTE15 VARCHAR2 (240)

[top of page]

JMF.JMF_SHIKYU_CFR_RPT_TEMP does not reference any database object

JMF.JMF_SHIKYU_CFR_RPT_TEMP is referenced by following:

APPS
SYNONYM - JMF_SHIKYU_CFR_RPT_TEMP

[top of page]

Table: JMF_SHIKYU_COMPONENTS

Description: JMF_SHIKYU_COMPONENTS stores the SHIKYU components required for manufacturing the outsourced assembly item of the subcontracting order shipment.
Primary Key: JMF_SHIKYU_COMPONENTS_PK
  1. SUBCONTRACT_PO_SHIPMENT_ID
  2. SHIKYU_COMPONENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JMF_SHIKYU_COMPONENTS.SUBCONTRACT_PO_SHIPMENT_ID JMF_SUBCONTRACT_ORDERS
JMF_SHIKYU_COMPONENTS.SHIKYU_COMPONENT_ID
JMF_SHIKYU_COMPONENTS.OEM_ORGANIZATION_ID 		MTL_SYSTEM_ITEMS_B
JMF_SHIKYU_COMPONENTS.CURRENCY FND_CURRENCIES
Comments

JMF_SHIKYU_COMPONENTS stores the SHIKYU components required for manufacturing the outsourced assembly item of the subcontracting order shipment.

Indexes
Index Type Tablespace Column
JMF_SHIKYU_COMPONENTS_U1 UNIQUE APPS_TS_TX_IDX SUBCONTRACT_PO_SHIPMENT_ID
SHIKYU_COMPONENT_ID
Columns
Name Datatype Length Mandatory Comments
SUBCONTRACT_PO_SHIPMENT_ID NUMBER
Y Unique identifier of the Subcontracting Order Shipment using this SHIKYU Component
SHIKYU_COMPONENT_ID NUMBER
Y Inventory Item ID of the SHIKYU Component
OEM_ORGANIZATION_ID NUMBER
Y Organization ID of the Subcontracting Organization
SHIKYU_COMPONENT_PRICE NUMBER

Price of the SHIKYU component from the Order Management price list
UOM VARCHAR2 (3)
Unit Of Measure (UOM) of the SHIKYU component price.
CURRENCY VARCHAR2 (15)
Unique identifier for the currency corresponding to the SHIKYU component price. Should be the same as the currency of the subcontract Purchase Order.
PRIMARY_UOM_PRICE NUMBER

Price of the component in its Primary UOM
PRIMARY_UOM VARCHAR2 (3)
Primary UOM of the component
QUANTITY NUMBER

Quantity needed of the component for the corresponding subcontracting order shipment
PRICE_LIST_ID NUMBER

Identifier of the Price List effective for the component.
REPLEN_SO_CREATION_FAILED VARCHAR2 (1)
Flag which indicates whether replenishment sales order creation failed
REQUEST_ID NUMBER

Standard Who column: the concurrent request that created or updated this record.
LAST_UPDATE_DATE DATE

Standard Who column: date when this record was last updated
LAST_UPDATED_BY NUMBER

Standard Who column: the user who last updated this record
CREATION_DATE DATE

Standard Who column: date when this record was created
CREATED_BY NUMBER

Standard Who column: the user who created this record
LAST_UPDATE_LOGIN NUMBER

Standard Who column: identifies sign-on audit information of the user who last updated this record
PROGRAM_ID NUMBER

Standard Who column: the concurrent program that created or updated this record
PROGRAM_UPDATE_DATE DATE

Standard Who column: the date when this record was created or updated by a concurrent program
PROGRAM_APPLICATION_ID NUMBER

Standard Who column: the application that owns the concurrent program that created or updated this record

[top of page]

JMF.JMF_SHIKYU_COMPONENTS does not reference any database object

JMF.JMF_SHIKYU_COMPONENTS is referenced by following:

APPS
SYNONYM - JMF_SHIKYU_COMPONENTS

[top of page]

Table: JMF_SHIKYU_CUR_RPT_TEMP

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
SOURCE VARCHAR2 (10)
INVENTORY_ORG_NAME VARCHAR2 (50)
PROJECT_NUM VARCHAR2 (50)
TASK_NUM VARCHAR2 (50)
VENDOR_NAME VARCHAR2 (50)
VENDOR_SITE_CODE VARCHAR2 (20)
ORDER_NUM VARCHAR2 (20)
LINE_NUM NUMBER

ITEM_ID NUMBER

ITEM_NAME VARCHAR2 (50)
ITEM_DESC VARCHAR2 (240)
UNIT_PRICE NUMBER

CURRENCY VARCHAR2 (15)
QUANTITY NUMBER

UOM_CODE VARCHAR2 (20)
UNIT_COST_FROZEN NUMBER

UNIT_COST_PLAN NUMBER

FUNC_UNIT_PRICE VARCHAR2 (20)
PRIMARY_QTY NUMBER

FUNC_CURRENCY_CODE VARCHAR2 (20)
ORDER_LINE_ID NUMBER

[top of page]

JMF.JMF_SHIKYU_CUR_RPT_TEMP does not reference any database object

JMF.JMF_SHIKYU_CUR_RPT_TEMP is referenced by following:

APPS
SYNONYM - JMF_SHIKYU_CUR_RPT_TEMP

[top of page]

Table: JMF_SHIKYU_REPLENISHMENTS

Description: JMF_SHIKYU_REPLENISHMENTS stores replenishment sales orders information created for the fulfilling requirements of a particular SHIKYU component item between a specific Origin Equipment Manufacturer (OEM) and Trading Partner Organization (T
Primary Key: JMF_SHIKYU_REPLENISHMENTS_PK
  1. REPLENISHMENT_SO_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JMF_SHIKYU_REPLENISHMENTS.REPLENISHMENT_SO_LINE_ID OE_ORDER_LINES_ALL
JMF_SHIKYU_REPLENISHMENTS.REPLENISHMENT_PO_SHIPMENT_ID PO_LINE_LOCATIONS_ALL
JMF_SHIKYU_REPLENISHMENTS.OEM_ORGANIZATION_ID MTL_PARAMETERS
JMF_SHIKYU_REPLENISHMENTS.TP_ORGANIZATION_ID MTL_PARAMETERS
JMF_SHIKYU_REPLENISHMENTS.TP_SUPPLIER_ID PO_VENDORS
JMF_SHIKYU_REPLENISHMENTS.TP_SUPPLIER_SITE_ID PO_VENDOR_SITES_ALL
JMF_SHIKYU_REPLENISHMENTS.SHIKYU_COMPONENT_ID
JMF_SHIKYU_REPLENISHMENTS.OEM_ORGANIZATION_ID 		MTL_SYSTEM_ITEMS_B
Comments

JMF_SHIKYU_REPLENISHMENTS stores replenishment sales orders information created for the fulfilling requirements of a particular SHIKYU component item between a specific Origin Equipment Manufacturer (OEM) and Trading Partner Organization (TP) The corresponding replenishment purchase orders are also stored in this table.

Indexes
Index Type Tablespace Column
JMF_SHIKYU_REPLENISHMENTS_U1 UNIQUE APPS_TS_TX_IDX REPLENISHMENT_SO_LINE_ID
JMF_SHIKYU_REPLENISHMENTS_N1 NONUNIQUE APPS_TS_TX_IDX REPLENISHMENT_PO_SHIPMENT_ID
JMF_SHIKYU_REPLENISHMENTS_N2 NONUNIQUE APPS_TS_TX_IDX REPLENISHMENT_SO_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
REPLENISHMENT_SO_LINE_ID NUMBER
Y Unique identifier of the replenishment sales order line.
REPLENISHMENT_SO_HEADER_ID NUMBER
Y Unique identifier of the replenishment sales order header.
SCHEDULE_SHIP_DATE DATE

Scheduled ship date of the corresponding replenishment sales order line.
REPLENISHMENT_PO_HEADER_ID NUMBER
Y Unique identifier of the associated replenishment purchase order header.
REPLENISHMENT_PO_LINE_ID NUMBER
Y Unique identifier of the associated replenishment purchase order line.
REPLENISHMENT_PO_SHIPMENT_ID NUMBER
Y Unique identifier of the associated replenishment purchase order shipment.
OEM_ORGANIZATION_ID NUMBER
Y Organization ID of the Subcontracting Organization.
TP_ORGANIZATION_ID NUMBER
Y Organization ID of the Manufacturing Partner (MP) or Trading Partner (TP)
TP_SUPPLIER_ID NUMBER
Y Supplier ID corresponding to the Manufacturing Partner.
OSA_ITEM_PRICE NUMBER

The price of the OSA Item, to be calculated by the Interlock SHIKYU concurrent program based on the sum of the components costs plus a service fee charged by the MP.
TP_SUPPLIER_SITE_ID NUMBER
Y Supplier site ID corresponding to the Manufacturing Partner.
ALLOCATED_QUANTITY NUMBER

Total quantity that has been allocated from this replenishment order line.
SHIKYU_COMPONENT_ID NUMBER
Y Item ID of the SHIKYU component.
CURRENCY VARCHAR2 (15)
Unique identifier for the currency corresponding to the price of the Outsourced Assembly.
ALLOCABLE_QUANTITY NUMBER

Total quantity of this replenishment sales order line that can be allocated. Might be different from the ordered quantity if shipped quantity is greater than ordered quantity.
ORG_ID NUMBER
Y Operating unit ID of the current replenishment order.
ORDERED_PRIMARY_UOM_QUANTITY NUMBER

Ordered quantity in the primary UOM of the component item.
ALLOCATED_PRIMARY_UOM_QUANTITY NUMBER

Total allocated quantity in the primary UOM of the component item.
ALLOCABLE_PRIMARY_UOM_QUANTITY NUMBER

Total allocable quantity in the primary UOM of the component item.
ORDERED_QUANTITY NUMBER

Ordered quantity of the current replenishment sales order line.
ADDITIONAL_SUPPLY VARCHAR2 (1)
Flag that signifies whether this replenishment was created as an additional supply for manual allocations through the SHIKYU Workbench or for consumption adjustments. Values 'Y', 'N'.(NULL will be taken as 'N').
STATUS VARCHAR2 (30)
Status of the replenishment sales order line. Is NULL initially, signifying that the line is still OPEN. Other statuses that are being tracked are CLOSED and CANCELLED.
UOM VARCHAR2 (3)
UOM of this replenishment sales order line, in which the component items will be shipped in.
PRIMARY_UOM VARCHAR2 (3)
Primary UOM code of the component to be shipped to the trading partner organization
REQUEST_ID NUMBER

Standard Who column: the concurrent request that created or updated this record.
LAST_UPDATE_DATE DATE

Standard Who column: date when this record was last updated
LAST_UPDATED_BY NUMBER

Standard Who column: the user who last updated this record
CREATION_DATE DATE

Standard Who column: date when this record was created
CREATED_BY NUMBER

Standard Who column: the user who created this record
LAST_UPDATE_LOGIN NUMBER

Standard Who column: identifies sign-on audit information of the user who last updated this record
PROGRAM_ID NUMBER

Standard Who column: the concurrent program that created or updated this record
PROGRAM_UPDATE_DATE DATE

Standard Who column: the date when this record was created or updated by a concurrent program
PROGRAM_APPLICATION_ID NUMBER

Standard Who column: the application that owns the concurrent program that created or updated this record

[top of page]

JMF.JMF_SHIKYU_REPLENISHMENTS does not reference any database object

JMF.JMF_SHIKYU_REPLENISHMENTS is referenced by following:

APPS
SYNONYM - JMF_SHIKYU_REPLENISHMENTS

[top of page]

Table: JMF_SHIKYU_SPR_RPT_TEMP

Description:
Comments
Primary Key: JMF_SHIKYU_SPR_RPT_TEMP_PK
  1. SUBCONTRACT_PO_SHIPMENT_ID
Indexes
Index Type Tablespace Column
JMF_SHIKYU_SPR_RPT_TEMP_PK UNIQUE SUBCONTRACT_PO_SHIPMENT_ID
Columns
Name Datatype Length Mandatory Comments
SUBCONTRACT_PO_SHIPMENT_ID NUMBER
Y
SHIPMENT_TYPE VARCHAR2 (25)
REPORT_TITLE_NUM VARCHAR2 (60)
SUB_PO_NUM VARCHAR2 (20)
AGENT_NAME VARCHAR2 (240)
SUB_PO_LINE_NUM NUMBER

SHIP_OR_RELEASE_NUM VARCHAR2 (20)
REV_NUM VARCHAR2 (20)
CREATION_DATE DATE

CREATED_BY_NAME VARCHAR2 (100)
REVISED_DATE DATE

REVISED_BY_NAME VARCHAR2 (100)
VENDOR_SITE_CODE VARCHAR2 (15)
VENDOR_CITY_STATE_ZIP VARCHAR2 (200)
VENDOR_COUNTRY VARCHAR2 (30)
VENDOR_SITE_ADDRESS1 VARCHAR2 (240)
VENDOR_SITE_ADDRESS2 VARCHAR2 (240)
VENDOR_SITE_ADDRESS3 VARCHAR2 (240)
SHIP_TO_SITE_CODE VARCHAR2 (60)
SHIP_TO_SITE_ADDRESS1 VARCHAR2 (240)
SHIP_TO_SITE_ADDRESS2 VARCHAR2 (240)
SHIP_TO_SITE_ADDRESS3 VARCHAR2 (240)
SHIP_TO_SITE_POSTAL_CODE VARCHAR2 (30)
SHIP_TO_SITE_COUNTRY VARCHAR2 (30)
BILL_TO_SITE_CODE VARCHAR2 (60)
BILL_TO_SITE_ADDRESS1 VARCHAR2 (240)
BILL_TO_SITE_ADDRESS2 VARCHAR2 (240)
BILL_TO_SITE_ADDRESS3 VARCHAR2 (240)
BILL_TO_SITE_POSTAL_CODE VARCHAR2 (30)
BILL_TO_SITE_COUNTRY VARCHAR2 (30)
CUSTOMER_NUM VARCHAR2 (25)
SUPPLIER_NUM VARCHAR2 (30)
PAY_TERM VARCHAR2 (50)
FREIGHT_TERM VARCHAR2 (80)
FOB_TYPE VARCHAR2 (80)
SHIPPING_CONTROL VARCHAR2 (80)
SHIP_VIA VARCHAR2 (25)
CONFIRM_TO_NAME VARCHAR2 (50)
CONFIRM_TO_TELEPHONE VARCHAR2 (15)
REQUESTER VARCHAR2 (300)
NOTES VARCHAR2 (480)
SHIPMENT_NUM NUMBER

PROJECT_NUM VARCHAR2 (25)
TASK_NUM VARCHAR2 (25)
ITEM_NUM VARCHAR2 (40)
ITEM_DESC VARCHAR2 (240)
NEED_BY_DATE DATE

PROMISED_DATE DATE

QUANTITY NUMBER

UOM VARCHAR2 (25)
ITEM_PRICE NUMBER

TAXABLE_FLAG VARCHAR2 (20)
AMOUNT NUMBER

AGENT_ID NUMBER

VENDOR_ID NUMBER

ITEM_ID NUMBER

CURRENCY_CODE VARCHAR2 (15)
COLUMN1 NUMBER

COLUMN2 NUMBER

COLUMN3 NUMBER

COLUMN4 NUMBER

COLUMN5 NUMBER

ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE2 VARCHAR2 (240)
ATTRIBUTE3 VARCHAR2 (240)
ATTRIBUTE4 VARCHAR2 (240)
ATTRIBUTE5 VARCHAR2 (240)

[top of page]

JMF.JMF_SHIKYU_SPR_RPT_TEMP does not reference any database object

JMF.JMF_SHIKYU_SPR_RPT_TEMP is referenced by following:

APPS
SYNONYM - JMF_SHIKYU_SPR_RPT_TEMP

[top of page]

Table: JMF_SUBCONTRACT_ORDERS

Description: JMF_SUBCONTRACT_ORDERS stores the SHIKYU subcontracting order information. The Interlock SHIKYU concurrent program will create a record in this table for each shipment line in the source outsourced assembly item purchase order.
Primary Key: JMF_SUBCONTRACT_ORDERS_PK
  1. SUBCONTRACT_PO_SHIPMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JMF_SUBCONTRACT_ORDERS.SUBCONTRACT_PO_SHIPMENT_ID PO_LINE_LOCATIONS_ALL
JMF_SUBCONTRACT_ORDERS.TASK_ID PA_TASKS
JMF_SUBCONTRACT_ORDERS.OEM_ORGANIZATION_ID MTL_PARAMETERS
JMF_SUBCONTRACT_ORDERS.TP_ORGANIZATION_ID MTL_PARAMETERS
JMF_SUBCONTRACT_ORDERS.WIP_ENTITY_ID WIP_DISCRETE_JOBS
JMF_SUBCONTRACT_ORDERS.OSA_ITEM_ID
JMF_SUBCONTRACT_ORDERS.OEM_ORGANIZATION_ID 		MTL_SYSTEM_ITEMS_B
JMF_SUBCONTRACT_ORDERS.CURRENCY FND_CURRENCIES
JMF_SUBCONTRACT_ORDERS.PROJECT_ID PA_PROJECTS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
JMF_SHIKYU_COMPONENTS.SUBCONTRACT_PO_SHIPMENT_ID JMF_SUBCONTRACT_ORDERS
Comments

JMF_SUBCONTRACT_ORDERS stores the SHIKYU subcontracting order information. The Interlock SHIKYU concurrent program will create a record in this table for each shipment line in the source outsourced assembly item purchase order.

Indexes
Index Type Tablespace Column
JMF_SUBCONTRACT_ORDERS_U1 UNIQUE APPS_TS_TX_IDX SUBCONTRACT_PO_SHIPMENT_ID
Columns
Name Datatype Length Mandatory Comments
SUBCONTRACT_PO_SHIPMENT_ID NUMBER
Y Unique identifier of the Subcontracting Order Shipment
SUBCONTRACT_PO_HEADER_ID NUMBER
Y Unique identifier of the Subcontracting Order Header
SUBCONTRACT_PO_LINE_ID NUMBER
Y Unique identifier of the Subcontracting Order Line
PROJECT_ID NUMBER

Project accounting project unique identifier
TASK_ID NUMBER

Project accounting task unique identifier
OEM_ORGANIZATION_ID NUMBER
Y Organization ID of the Subcontracting Organization
TP_ORGANIZATION_ID NUMBER
Y Organization ID of the Manufacturing Partner (MP) or Trading Partner (TP)
WIP_ENTITY_ID NUMBER

Unique Identifier of the WIP job created for manufacturing the OSA item in the MP Organization
OSA_ITEM_ID NUMBER
Y Identifier of the Out Sourced Assembly item (OSA)
OSA_ITEM_PRICE NUMBER

The price of the OSA Item, to be calculated by the Interlock SHIKYU concurrent program based on the sum of the components costs plus a service fee charged by the MP.
NEED_BY_DATE DATE

Need by date of the Subcontracting Order Shipment. Will be updated by the Reconciliation Concurrent Program in case this has been changed on the corresponding Subcontracting Purchase Order Shipment Line.
UOM VARCHAR2 (3)
Unit Of Measure (UOM) of the subcontracting Order.
CURRENCY VARCHAR2 (15)
Unique identifier for the currency corresponding to the price of the Outsourced Assembly.
QUANTITY NUMBER

Quantity of the OSA item to be purchased through the current Subcontracting Order Shipment.
INTERLOCK_STATUS VARCHAR2 (1)
To be stamped by the Values: P (Processed), E (Error), R (Reconciled), I (Incomplete), C (Closed).
BATCH_ID NUMBER

To group subcontracting orders in batches for processing.
REQUEST_ID NUMBER

Standard Who column: the concurrent request that created or updated this record.
LAST_UPDATE_DATE DATE

Standard Who column: date when this record was last updated
LAST_UPDATED_BY NUMBER

Standard Who column: the user who last updated this record
CREATION_DATE DATE

Standard Who column: date when this record was created
CREATED_BY NUMBER

Standard Who column: the user who created this record
LAST_UPDATE_LOGIN NUMBER

Standard Who column: identifies sign-on audit information of the user who last updated this record
PROGRAM_ID NUMBER

Standard Who column: the concurrent program that created or updated this record
PROGRAM_UPDATE_DATE DATE

Standard Who column: the date when this record was created or updated by a concurrent program
PROGRAM_APPLICATION_ID NUMBER

Standard Who column: the application that owns the concurrent program that created or updated this record

[top of page]

JMF.JMF_SUBCONTRACT_ORDERS does not reference any database object

JMF.JMF_SUBCONTRACT_ORDERS is referenced by following:

APPS
SYNONYM - JMF_SUBCONTRACT_ORDERS

[top of page]

Table: JMF_SUBCONTRACT_ORDERS_TEMP

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
SUBCONTRACT_PO_SHIPMENT_ID NUMBER

SUBCONTRACT_PO_HEADER_ID NUMBER

SUBCONTRACT_PO_LINE_ID NUMBER

OEM_ORGANIZATION_ID NUMBER

TP_ORGANIZATION_ID NUMBER

NEED_BY_DATE DATE

VENDOR_ID NUMBER

VENDOR_SITE_ID NUMBER

UOM VARCHAR2 (3)
CURRENCY VARCHAR2 (15)
QUANTITY NUMBER

OSA_ITEM_ID NUMBER

OSA_ITEM_PRICE NUMBER

PROJECT_ID NUMBER

TASK_ID NUMBER

[top of page]

JMF.JMF_SUBCONTRACT_ORDERS_TEMP does not reference any database object

JMF.JMF_SUBCONTRACT_ORDERS_TEMP is referenced by following:

APPS
SYNONYM - JMF_SUBCONTRACT_ORDERS_TEMP

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract