VIEW: APPS.WSM_SM_STARTING_JOBS_V

Source

View Text - Preformatted

SELECT distinct(WSSJ.ROWID), WSSJ.TRANSACTION_ID, WSSJ.WIP_ENTITY_ID, WSSJ.WIP_ENTITY_NAME, WDJ.CLASS_CODE, WDJ.KANBAN_CARD_ID, WSSJ.DESCRIPTION, WSSJ.representative_flag, decode(WSSJ.PRIMARY_ITEM_ID, NULL, WDJ.PRIMARY_ITEM_ID, WSSJ.PRIMARY_ITEM_ID) primary_item_id, WSSJ.OPERATION_SEQ_NUM, nvl(BSO.operation_code, ''), nvl(WO.standard_operation_id, ''), BOS.operation_description, WSSJ.INTRAOPERATION_STEP, BD.department_code, BD.department_id, mfg.meaning, WSSJ.available_quantity, WSSJ.job_start_quantity, WO.QUANTITY_COMPLETED, decode(WDJ.JOB_TYPE, 1, 'STANDARD', 3, 'NON-STANDARD', 'STANDARD'), WSSJ.SCHEDULED_START_DATE, WSSJ.SCHEDULED_COMPLETION_DATE, WSSJ.completion_subinventory, WSSJ.completion_locator_id, WSSJ.bom_reference_id, WSSJ.bill_sequence_id, WSSJ.bom_revision, WSSJ.bom_revision_date, BBOM.alternate_bom_designator, WSSJ.routing_reference_id, WSSJ.routing_seq_id, WSSJ.routing_revision, WSSJ.routing_revision_date, BOR.alternate_routing_designator, WSSJ.LAST_UPDATE_DATE, WSSJ.LAST_UPDATED_BY, WSSJ.CREATION_DATE, WSSJ.CREATED_BY, WSSJ.LAST_UPDATE_LOGIN, WSSJ.ATTRIBUTE_CATEGORY, WSSJ.ATTRIBUTE1, WSSJ.ATTRIBUTE2, WSSJ.ATTRIBUTE3, WSSJ.ATTRIBUTE4, WSSJ.ATTRIBUTE5, WSSJ.ATTRIBUTE6, WSSJ.ATTRIBUTE7, WSSJ.ATTRIBUTE8, WSSJ.ATTRIBUTE9, WSSJ.ATTRIBUTE10, WSSJ.ATTRIBUTE11, WSSJ.ATTRIBUTE12, WSSJ.ATTRIBUTE13, WSSJ.ATTRIBUTE14, WSSJ.ATTRIBUTE15, WSSJ.REQUEST_ID, WSSJ.PROGRAM_APPLICATION_ID, WSSJ.PROGRAM_ID, WSSJ.PROGRAM_UPDATE_DATE, WSSJ.coproducts_supply, WSSJ.net_quantity, KC.KANBAN_CARD_NUMBER from WSM_SM_STARTING_JOBS WSSJ, wip_discrete_jobs WDJ, wip_operations WO, bom_standard_operations BSO, mfg_lookups mfg, bom_departments BD, bom_operation_sequences BOS, bom_operational_routings bor, bom_bill_of_materials bbom, mtl_kanban_cards KC WHERE WDJ.wip_entity_id = WSSJ.wip_entity_id and WO.wip_entity_id = WSSJ.wip_entity_id and WO.organization_id = WSSJ.organization_id and WO.repetitive_schedule_id is NULL and WO.operation_seq_num = WSSJ.operation_seq_num and mfg.lookup_type = 'WIP_INTRAOPERATION_STEP' and mfg.lookup_code = WSSJ.intraoperation_step and WSSJ.department_id = bd.department_id (+) and wssj.routing_seq_id = bos.routing_sequence_id (+) and WSSJ.operation_sequence_id = bos.operation_sequence_id (+) and NVL(wssj.routing_seq_id, -9999) = bor.routing_sequence_id (+) and BOS.standard_operation_id = BSO.standard_operation_id (+) and WSSJ.bill_sequence_id = BBOM.bill_sequence_id (+) and WDJ.KANBAN_CARD_ID = KC.KANBAN_CARD_ID(+)

View Text - HTML Formatted

SELECT DISTINCT(WSSJ.ROWID)
, WSSJ.TRANSACTION_ID
, WSSJ.WIP_ENTITY_ID
, WSSJ.WIP_ENTITY_NAME
, WDJ.CLASS_CODE
, WDJ.KANBAN_CARD_ID
, WSSJ.DESCRIPTION
, WSSJ.REPRESENTATIVE_FLAG
, DECODE(WSSJ.PRIMARY_ITEM_ID
, NULL
, WDJ.PRIMARY_ITEM_ID
, WSSJ.PRIMARY_ITEM_ID) PRIMARY_ITEM_ID
, WSSJ.OPERATION_SEQ_NUM
, NVL(BSO.OPERATION_CODE
, '')
, NVL(WO.STANDARD_OPERATION_ID
, '')
, BOS.OPERATION_DESCRIPTION
, WSSJ.INTRAOPERATION_STEP
, BD.DEPARTMENT_CODE
, BD.DEPARTMENT_ID
, MFG.MEANING
, WSSJ.AVAILABLE_QUANTITY
, WSSJ.JOB_START_QUANTITY
, WO.QUANTITY_COMPLETED
, DECODE(WDJ.JOB_TYPE
, 1
, 'STANDARD'
, 3
, 'NON-STANDARD'
, 'STANDARD')
, WSSJ.SCHEDULED_START_DATE
, WSSJ.SCHEDULED_COMPLETION_DATE
, WSSJ.COMPLETION_SUBINVENTORY
, WSSJ.COMPLETION_LOCATOR_ID
, WSSJ.BOM_REFERENCE_ID
, WSSJ.BILL_SEQUENCE_ID
, WSSJ.BOM_REVISION
, WSSJ.BOM_REVISION_DATE
, BBOM.ALTERNATE_BOM_DESIGNATOR
, WSSJ.ROUTING_REFERENCE_ID
, WSSJ.ROUTING_SEQ_ID
, WSSJ.ROUTING_REVISION
, WSSJ.ROUTING_REVISION_DATE
, BOR.ALTERNATE_ROUTING_DESIGNATOR
, WSSJ.LAST_UPDATE_DATE
, WSSJ.LAST_UPDATED_BY
, WSSJ.CREATION_DATE
, WSSJ.CREATED_BY
, WSSJ.LAST_UPDATE_LOGIN
, WSSJ.ATTRIBUTE_CATEGORY
, WSSJ.ATTRIBUTE1
, WSSJ.ATTRIBUTE2
, WSSJ.ATTRIBUTE3
, WSSJ.ATTRIBUTE4
, WSSJ.ATTRIBUTE5
, WSSJ.ATTRIBUTE6
, WSSJ.ATTRIBUTE7
, WSSJ.ATTRIBUTE8
, WSSJ.ATTRIBUTE9
, WSSJ.ATTRIBUTE10
, WSSJ.ATTRIBUTE11
, WSSJ.ATTRIBUTE12
, WSSJ.ATTRIBUTE13
, WSSJ.ATTRIBUTE14
, WSSJ.ATTRIBUTE15
, WSSJ.REQUEST_ID
, WSSJ.PROGRAM_APPLICATION_ID
, WSSJ.PROGRAM_ID
, WSSJ.PROGRAM_UPDATE_DATE
, WSSJ.COPRODUCTS_SUPPLY
, WSSJ.NET_QUANTITY
, KC.KANBAN_CARD_NUMBER
FROM WSM_SM_STARTING_JOBS WSSJ
, WIP_DISCRETE_JOBS WDJ
, WIP_OPERATIONS WO
, BOM_STANDARD_OPERATIONS BSO
, MFG_LOOKUPS MFG
, BOM_DEPARTMENTS BD
, BOM_OPERATION_SEQUENCES BOS
, BOM_OPERATIONAL_ROUTINGS BOR
, BOM_BILL_OF_MATERIALS BBOM
, MTL_KANBAN_CARDS KC
WHERE WDJ.WIP_ENTITY_ID = WSSJ.WIP_ENTITY_ID
AND WO.WIP_ENTITY_ID = WSSJ.WIP_ENTITY_ID
AND WO.ORGANIZATION_ID = WSSJ.ORGANIZATION_ID
AND WO.REPETITIVE_SCHEDULE_ID IS NULL
AND WO.OPERATION_SEQ_NUM = WSSJ.OPERATION_SEQ_NUM
AND MFG.LOOKUP_TYPE = 'WIP_INTRAOPERATION_STEP'
AND MFG.LOOKUP_CODE = WSSJ.INTRAOPERATION_STEP
AND WSSJ.DEPARTMENT_ID = BD.DEPARTMENT_ID (+)
AND WSSJ.ROUTING_SEQ_ID = BOS.ROUTING_SEQUENCE_ID (+)
AND WSSJ.OPERATION_SEQUENCE_ID = BOS.OPERATION_SEQUENCE_ID (+)
AND NVL(WSSJ.ROUTING_SEQ_ID
, -9999) = BOR.ROUTING_SEQUENCE_ID (+)
AND BOS.STANDARD_OPERATION_ID = BSO.STANDARD_OPERATION_ID (+)
AND WSSJ.BILL_SEQUENCE_ID = BBOM.BILL_SEQUENCE_ID (+)
AND WDJ.KANBAN_CARD_ID = KC.KANBAN_CARD_ID(+)