VIEW: APPS.OPI_WMS_OP_PLAN_NAME_LVL_V

Source

View Text - Preformatted

SELECT tl.operation_plan_id id, tl.operation_plan_name value, b.organization_id org_id from wms_op_plans_tl tl, wms_op_plans_b b WHERE tl.language = userenv ('LANG')and b.operation_plan_id = tl.operation_plan_id

View Text - HTML Formatted

SELECT TL.OPERATION_PLAN_ID ID
, TL.OPERATION_PLAN_NAME VALUE
, B.ORGANIZATION_ID ORG_ID
FROM WMS_OP_PLANS_TL TL
, WMS_OP_PLANS_B B
WHERE TL.LANGUAGE = USERENV ('LANG')AND B.OPERATION_PLAN_ID = TL.OPERATION_PLAN_ID