VIEW: APPS.CSM_MTL_INTERORG_PARAMETERS_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID, acc.FROM_ORGANIZATION_ID , acc.TO_ORGANIZATION_ID, interOrg.internal_order_required_flag, interOrg.INTRANSIT_TYPE From CSM_INTERORG_PARAMETERS_ACC acc ,MTL_INTERORG_PARAMETERS interOrg WHERE acc.user_id=asg_base.get_user_id AND acc.from_organization_id = interOrg.from_organization_id AND acc.to_organization_id = interOrg.to_organization_id

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, ACC.FROM_ORGANIZATION_ID
, ACC.TO_ORGANIZATION_ID
, INTERORG.INTERNAL_ORDER_REQUIRED_FLAG
, INTERORG.INTRANSIT_TYPE
FROM CSM_INTERORG_PARAMETERS_ACC ACC
, MTL_INTERORG_PARAMETERS INTERORG
WHERE ACC.USER_ID=ASG_BASE.GET_USER_ID
AND ACC.FROM_ORGANIZATION_ID = INTERORG.FROM_ORGANIZATION_ID
AND ACC.TO_ORGANIZATION_ID = INTERORG.TO_ORGANIZATION_ID