INV_INTERORG_PARAMETERS

Details

Schema: FUSION
Object owner: INV
Object type: VIEW

Columns

Name
INTERORG_PARAMETERS_ID FROM_ORGANIZATION_ID TO_ORGANIZATION_ID TO_ORGANIZATION_CODE FROM_ORGANIZATION_CODE TO_ORG_DISTANCE_BASE_UOM INTRANSIT_TYPE TO_ORGANIZATION_DISTANCE DISTANCE_UOM_CODE MATL_INTERORG_TRANSFER_CODE FOB_POINT INTERORG_TRNSFR_CHARGE_PERCENT ROUTING_HEADER_ID MANUAL_RECEIPT_EXPENSE INTERNAL_PROFIT_TRACKING TRANSFER_PRICING_OPTION LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN ATTRIBUTE_CATEGORY 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 OBJECT_VERSION_NUMBER TRANSFER_ORDER_REQUIRED EXPENSE_DEST_RECEIPT_ROUTING FILL_KILL_INV_TO_LOOKUP FILL_KILL_EXP_TO_LOOKUP TO_ORGANIZATION_NAME ENABLED_DATE DISABLE_DATE ORG_STATUS

Name

INTERORG_PARAMETERS_ID

FROM_ORGANIZATION_ID

TO_ORGANIZATION_ID

TO_ORGANIZATION_CODE

FROM_ORGANIZATION_CODE

TO_ORG_DISTANCE_BASE_UOM

INTRANSIT_TYPE

TO_ORGANIZATION_DISTANCE

DISTANCE_UOM_CODE

MATL_INTERORG_TRANSFER_CODE

FOB_POINT

INTERORG_TRNSFR_CHARGE_PERCENT

ROUTING_HEADER_ID

MANUAL_RECEIPT_EXPENSE

INTERNAL_PROFIT_TRACKING

TRANSFER_PRICING_OPTION

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

ATTRIBUTE_CATEGORY

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

OBJECT_VERSION_NUMBER

TRANSFER_ORDER_REQUIRED

EXPENSE_DEST_RECEIPT_ROUTING

FILL_KILL_INV_TO_LOOKUP

FILL_KILL_EXP_TO_LOOKUP

TO_ORGANIZATION_NAME

ENABLED_DATE

DISABLE_DATE

ORG_STATUS

Query

SQL_Statement
SELECT IOP.INTERORG_PARAMETERS_ID, IOP.FROM_ORGANIZATION_ID, IOP.TO_ORGANIZATION_ID, IP.ORGANIZATION_CODE AS TO_ORGANIZATION_CODE, IP2.ORGANIZATION_CODE AS FROM_ORGANIZATION_CODE, DECODE(DECODE(DECODE(IOP.TO_ORGANIZATION_DISTANCE,NULL,0,1),0,0,DECODE(IOP.DISTANCE_UOM_CODE,NULL,0,1)),1,INV_VALIDATE.GET_DISTANCE_IN_BASE_UOM(IOP.TO_ORGANIZATION_DISTANCE,IOP.DISTANCE_UOM_CODE),99999999) AS TO_ORG_DISTANCE_BASE_UOM, IOP.INTRANSIT_TYPE, IOP.TO_ORGANIZATION_DISTANCE, IOP.DISTANCE_UOM_CODE, IOP.MATL_INTERORG_TRANSFER_CODE, IOP.FOB_POINT, IOP.INTERORG_TRNSFR_CHARGE_PERCENT, IOP.ROUTING_HEADER_ID, IOP.MANUAL_RECEIPT_EXPENSE, IOP.INTERNAL_PROFIT_TRACKING, IOP.TRANSFER_PRICING_OPTION, IOP.LAST_UPDATE_DATE, IOP.LAST_UPDATED_BY, IOP.CREATION_DATE, IOP.CREATED_BY, IOP.LAST_UPDATE_LOGIN, IOP.ATTRIBUTE_CATEGORY, IOP.ATTRIBUTE1, IOP.ATTRIBUTE2, IOP.ATTRIBUTE3, IOP.ATTRIBUTE4, IOP.ATTRIBUTE5, IOP.ATTRIBUTE6, IOP.ATTRIBUTE7, IOP.ATTRIBUTE8, IOP.ATTRIBUTE9, IOP.ATTRIBUTE10, IOP.ATTRIBUTE11, IOP.ATTRIBUTE12, IOP.ATTRIBUTE13, IOP.ATTRIBUTE14, IOP.ATTRIBUTE15, IOP.GLOBAL_ATTRIBUTE_CATEGORY, IOP.GLOBAL_ATTRIBUTE1, IOP.GLOBAL_ATTRIBUTE2, IOP.GLOBAL_ATTRIBUTE3, IOP.GLOBAL_ATTRIBUTE4, IOP.GLOBAL_ATTRIBUTE5, IOP.GLOBAL_ATTRIBUTE6, IOP.GLOBAL_ATTRIBUTE7, IOP.GLOBAL_ATTRIBUTE8, IOP.GLOBAL_ATTRIBUTE9, IOP.GLOBAL_ATTRIBUTE10, IOP.GLOBAL_ATTRIBUTE11, IOP.GLOBAL_ATTRIBUTE12, IOP.GLOBAL_ATTRIBUTE13, IOP.GLOBAL_ATTRIBUTE14, IOP.GLOBAL_ATTRIBUTE15, IOP.GLOBAL_ATTRIBUTE16, IOP.GLOBAL_ATTRIBUTE17, IOP.GLOBAL_ATTRIBUTE18, IOP.GLOBAL_ATTRIBUTE19, IOP.GLOBAL_ATTRIBUTE20, IOP.OBJECT_VERSION_NUMBER, IOP.TRANSFER_ORDER_REQUIRED, IOP.EXPENSE_DEST_RECEIPT_ROUTING, IOP.FILL_KILL_INV_TO_LOOKUP, IOP.FILL_KILL_EXP_TO_LOOKUP, HOU.NAME AS TO_ORGANIZATION_NAME, HOU.DATE_FROM ENABLED_DATE, HOU.DATE_TO DISABLE_DATE, HOI1.STATUS ORG_STATUS FROM HR_ORGANIZATION_UNITS HOU, HR_ORG_UNIT_CLASSIFICATIONS_X HOI1, INV_INTERORG_PARAMETERS IOP, INV_ORG_PARAMETERS IP, INV_ORG_PARAMETERS IP2 WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID AND HOU.ORGANIZATION_ID = IOP.TO_ORGANIZATION_ID AND HOI1.CLASSIFICATION_CODE = 'INV' AND IP.ORGANIZATION_ID = IOP.TO_ORGANIZATION_ID AND IP2.ORGANIZATION_ID = IOP.FROM_ORGANIZATION_ID

SQL_Statement

SELECT IOP.INTERORG_PARAMETERS_ID,

IOP.FROM_ORGANIZATION_ID,

IOP.TO_ORGANIZATION_ID,

IP.ORGANIZATION_CODE AS TO_ORGANIZATION_CODE,

IP2.ORGANIZATION_CODE AS FROM_ORGANIZATION_CODE,

DECODE(DECODE(DECODE(IOP.TO_ORGANIZATION_DISTANCE,NULL,0,1),0,0,DECODE(IOP.DISTANCE_UOM_CODE,NULL,0,1)),1,INV_VALIDATE.GET_DISTANCE_IN_BASE_UOM(IOP.TO_ORGANIZATION_DISTANCE,IOP.DISTANCE_UOM_CODE),99999999) AS TO_ORG_DISTANCE_BASE_UOM,

IOP.INTRANSIT_TYPE,

IOP.TO_ORGANIZATION_DISTANCE,

IOP.DISTANCE_UOM_CODE,

IOP.MATL_INTERORG_TRANSFER_CODE,

IOP.FOB_POINT,

IOP.INTERORG_TRNSFR_CHARGE_PERCENT,

IOP.ROUTING_HEADER_ID,

IOP.MANUAL_RECEIPT_EXPENSE,

IOP.INTERNAL_PROFIT_TRACKING,

IOP.TRANSFER_PRICING_OPTION,

IOP.LAST_UPDATE_DATE,

IOP.LAST_UPDATED_BY,

IOP.CREATION_DATE,

IOP.CREATED_BY,

IOP.LAST_UPDATE_LOGIN,

IOP.ATTRIBUTE_CATEGORY,

IOP.ATTRIBUTE1,

IOP.ATTRIBUTE2,

IOP.ATTRIBUTE3,

IOP.ATTRIBUTE4,

IOP.ATTRIBUTE5,

IOP.ATTRIBUTE6,

IOP.ATTRIBUTE7,

IOP.ATTRIBUTE8,

IOP.ATTRIBUTE9,

IOP.ATTRIBUTE10,

IOP.ATTRIBUTE11,

IOP.ATTRIBUTE12,

IOP.ATTRIBUTE13,

IOP.ATTRIBUTE14,

IOP.ATTRIBUTE15,

IOP.GLOBAL_ATTRIBUTE_CATEGORY,

IOP.GLOBAL_ATTRIBUTE1,

IOP.GLOBAL_ATTRIBUTE2,

IOP.GLOBAL_ATTRIBUTE3,

IOP.GLOBAL_ATTRIBUTE4,

IOP.GLOBAL_ATTRIBUTE5,

IOP.GLOBAL_ATTRIBUTE6,

IOP.GLOBAL_ATTRIBUTE7,

IOP.GLOBAL_ATTRIBUTE8,

IOP.GLOBAL_ATTRIBUTE9,

IOP.GLOBAL_ATTRIBUTE10,

IOP.GLOBAL_ATTRIBUTE11,

IOP.GLOBAL_ATTRIBUTE12,

IOP.GLOBAL_ATTRIBUTE13,

IOP.GLOBAL_ATTRIBUTE14,

IOP.GLOBAL_ATTRIBUTE15,

IOP.GLOBAL_ATTRIBUTE16,

IOP.GLOBAL_ATTRIBUTE17,

IOP.GLOBAL_ATTRIBUTE18,

IOP.GLOBAL_ATTRIBUTE19,

IOP.GLOBAL_ATTRIBUTE20,

IOP.OBJECT_VERSION_NUMBER,

IOP.TRANSFER_ORDER_REQUIRED,

IOP.EXPENSE_DEST_RECEIPT_ROUTING,

IOP.FILL_KILL_INV_TO_LOOKUP,

IOP.FILL_KILL_EXP_TO_LOOKUP,

HOU.NAME AS TO_ORGANIZATION_NAME,

HOU.DATE_FROM ENABLED_DATE,

HOU.DATE_TO DISABLE_DATE,

HOI1.STATUS ORG_STATUS

FROM HR_ORGANIZATION_UNITS HOU,

HR_ORG_UNIT_CLASSIFICATIONS_X HOI1,

INV_INTERORG_PARAMETERS IOP,

INV_ORG_PARAMETERS IP,

INV_ORG_PARAMETERS IP2

WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID

AND HOU.ORGANIZATION_ID = IOP.TO_ORGANIZATION_ID

AND HOI1.CLASSIFICATION_CODE = 'INV'

AND IP.ORGANIZATION_ID = IOP.TO_ORGANIZATION_ID

AND IP2.ORGANIZATION_ID = IOP.FROM_ORGANIZATION_ID