機械翻訳について

INV_OPEN_PICK_LINES_V

詳細

• スキーマ: FUSION

• オブジェクト所有者: INV

• オブジェクト・タイプ: VIEW

列

名前

PICK_SLIP_LINE PICK_SLIP PICKWAVE_NUMBER ORGANIZATION_ID ORGANIZATION_CODE ITEM REVISION REQUESTED_QUANTITY UOM SECONDARY_REQUESTED_QUANTITY SECONDARY_UOM SOURCE_SUBINVENTORY TRANSACTION_SOURCE_TYPE_ID TRANSACTION_TYPE_ID TRANSACTION_ACTION_ID SOURCE_LOCATOR_ID SOURCE_LOCATOR DESTINATION_SUBINVENTORY DESTINATION_LOCATOR DESTINATION_ACCOUNT ORDER_NUMBER SOURCE_ORDER SOURCE_ORDER_LINE MOVEMENT_REQUEST MOVEMENT_REQUEST_LINE PICK_SLIP_TYPE SHIPMENT_NUMBER SHIPPING_METHOD SHIPPING_PRIORITY CUSTOMER SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_TYPE REQUIRED_DATE DUE_DATE TRANSACTION_TYPE TRANSACTION_DATE TRANSACTION_ID CREATION_DATE PROJECT_ID TASK_ID COUNTRY_OF_ORIGIN_CODE COMN_SUPPLY_PRJ_DEMAND_FLAG

問合せ

SQL_Statement

SELECT mmtt.pick_slip_line_number pick_slip_line , mmtt.pick_slip_number as pick_slip , wdd.batch_id as pickwave_number , mmtt.organization_id , iop.organization_code as organization_code , esib.item_number as item , mmtt.revision , transaction_quantity as requested_quantity , txnUom.unit_of_measure as uom , secondary_transaction_quantity as secondary_requested_quantity , secondaryUom.unit_of_measure as secondary_uom , mmtt.subinventory_code as source_subinventory , mmtt.transaction_source_type_id , mmtt.transaction_type_id , mmtt.transaction_action_id , mmtt.locator_id as source_locator_id , Decode(mmtt.locator_id, null , null, FND_FLEX_EXT.GET_SEGS('INV','MTLL',sourceLoc.structure_instance_number,mmtt.locator_id,sourceLoc.subinventory_id)) AS source_locator , transfer_subinventory as destination_subinventory , DECODE(mmtt.transfer_to_location, null, null, FND_FLEX_EXT.GET_SEGS('INV','MTLL',destLoc.structure_instance_number,mmtt.transfer_to_location,destLoc.subinventory_id)) AS destination_locator , null as destination_account , wdd.sales_order_number as order_number , wdd.source_header_number as source_order , wdd.source_line_number as source_order_line , moh.request_number as movement_request , mol.line_number as movement_request_line , pickTypeLookup.meaning as pick_slip_type , wnd.delivery_name as shipment_number , decode (hp.party_name || '-' || modeOfTransportLK.meaning || '-' || serviceLevelLK.meaning , ' , hp.party_name || '-' || modeOfTransportLK.meaning || '-' || serviceLevelLK.meaning) AS shipping_method , shippingPriorityLK.meaning as shipping_priority , hzp.party_name as customer , wdd.ship_to_location_id , wdd.ship_to_location_type , wdd.date_requested as required_date , NVL(wnd.initial_pickup_date, wdd.date_scheduled) AS due_date , ittv.transaction_type_name as transaction_type , mmtt.transaction_date , mmtt.transaction_temp_id transaction_id , mmtt.creation_date , mmtt.PROJECT_ID , mmtt.TASK_ID , mmtt.COUNTRY_OF_ORIGIN_CODE , NVL(esib.COMN_SUPPLY_PRJ_DEMAND_FLAG, 'Y') AS COMN_SUPPLY_PRJ_DEMAND_FLAG FROM inv_material_txns_temp mmtt , inv_txn_request_lines mol , inv_txn_request_headers moh , wsh_delivery_details wdd , wsh_delivery_assignments wda , wsh_new_deliveries wnd , egp_system_items_b_v esib , inv_units_of_measure_vl txnUom , inv_units_of_measure_vl secondaryUom , fnd_lookups shippingPriorityLK , hz_parties hzp , inv_transaction_types_vl ittv , inv_item_locations sourceLoc , inv_item_locations destLoc , fnd_lookups pickTypeLookup , inv_org_parameters iop , hz_parties hp , fnd_lookups modeOfTransportLK , fnd_lookups serviceLevelLK WHERE mmtt.move_order_line_id = mol.line_id AND mmtt.transaction_type_id = mol.transaction_type_id AND moh.header_id = mol.header_id AND mmtt.organization_id = iop.organization_id AND wdd.delivery_detail_id = wda.delivery_detail_id(+) AND wda.delivery_id = wnd.delivery_id(+) AND mmtt.move_order_line_id = wdd.move_order_line_id AND mmtt.inventory_item_id = esib.inventory_item_id AND mmtt.organization_id = esib.organization_id AND mmtt.transaction_uom = txnUom.uom_code AND mmtt.secondary_uom_code = secondaryUom.uom_code (+) AND wdd.shipment_priority_code = shippingPriorityLK.lookup_code (+) AND shippingPriorityLK.lookup_type (+) = 'WSH_SHIPPING_PRIORITY' AND wdd.ship_to_party_id = hzp.party_id (+) AND mmtt.transaction_type_id = ittv.transaction_type_id AND mmtt.locator_id = sourceLoc.inventory_location_id (+) AND mmtt.subinventory_code = sourceLoc.subinventory_code (+) AND mmtt.organization_id = sourceLoc.organization_id (+) AND mmtt.transfer_to_location = destLoc.inventory_location_id (+) AND mmtt.transfer_subinventory = destLoc.subinventory_code (+) AND nvl(mmtt.transfer_organization, mmtt.organization_id) = destLoc.organization_id (+) AND moh.move_order_type =3 AND pickTypeLookup.lookup_type = 'INV_MOVE_ORDER_TYPE' AND pickTypeLookup.lookup_code = moh.move_order_type AND wdd.carrier_id = hp.party_id (+) AND wdd.service_level = serviceLevelLK.lookup_code (+) AND serviceLevelLK.lookup_type (+) = 'WSH_SERVICE_LEVELS' AND wdd.mode_of_transport = modeOfTransportLK.lookup_code (+) AND modeOfTransportLK.lookup_type (+) = 'WSH_MODE_OF_TRANSPORT' UNION ALL SELECT mmtt.pick_slip_line_number pick_slip_line , mmtt.pick_slip_number as pick_slip , NULL as pickwave_number , mmtt.organization_id , iop.organization_code as organization_code , esib.item_number as item , mmtt.revision , transaction_quantity as requested_quantity , txnUom.unit_of_measure as uom , secondary_transaction_quantity as secondary_requested_quantity , secondaryUom.unit_of_measure as secondary_uom , mmtt.subinventory_code as source_subinventory , mmtt.transaction_source_type_id , mmtt.transaction_type_id , mmtt.transaction_action_id , mmtt.locator_id as source_locator_id , Decode(mmtt.locator_id, null , null, FND_FLEX_EXT.GET_SEGS('INV','MTLL',sourceLoc.structure_instance_number,mmtt.locator_id,sourceLoc.subinventory_id)) AS source_locator , transfer_subinventory as destination_subinventory , DECODE(mmtt.transfer_to_location, null, null, FND_FLEX_EXT.GET_SEGS('INV','MTLL',destLoc.structure_instance_number,mmtt.transfer_to_location,destLoc.subinventory_id)) AS destination_locator , DECODE(mmtt.transaction_action_id, 1, (FND_FLEX_EXT.GET_SEGS('GL','GL#',(select chart_of_accounts_id from inv_organization_definitions_v where organization_id = mmtt.organization_id),distribution_account_id)), null) as destination_account , moh.request_number as order_number , null as source_order , null as source_order_line , moh.request_number as movement_request , mol.line_number as movement_request_line , pickTypeLookup.meaning as pick_slip_type , NULL as shipment_number , NULL as shipping_method , null as shipping_priority , null as customer , null as ship_to_location_id , null as ship_to_location_type , mol.DATE_REQUIRED as required_date , mol.date_required as due_date , ittv.transaction_type_name as transaction_type , mmtt.transaction_date , mmtt.transaction_temp_id transaction_id , mmtt.creation_date , mmtt.PROJECT_ID , mmtt.TASK_ID , mmtt.COUNTRY_OF_ORIGIN_CODE , NVL(esib.COMN_SUPPLY_PRJ_DEMAND_FLAG, 'Y') AS COMN_SUPPLY_PRJ_DEMAND_FLAG FROM inv_material_txns_temp mmtt , inv_txn_request_lines mol , inv_txn_request_headers moh , egp_system_items_b_v esib , inv_units_of_measure_vl txnUom , inv_units_of_measure_vl secondaryUom , inv_transaction_types_vl ittv , inv_item_locations sourceLoc , inv_item_locations destLoc , fnd_lookups pickTypeLookup , inv_org_parameters iop WHERE mmtt.move_order_line_id = mol.line_id AND mmtt.transaction_type_id = mol.transaction_type_id AND moh.header_id = mol.header_id AND mmtt.organization_id = iop.organization_id AND mmtt.inventory_item_id = esib.inventory_item_id AND mmtt.organization_id = esib.organization_id AND mmtt.transaction_uom = txnUom.uom_code AND mmtt.secondary_uom_code = secondaryUom.uom_code (+) AND mmtt.transaction_type_id = ittv.transaction_type_id AND mmtt.locator_id = sourceLoc.inventory_location_id (+) AND mmtt.subinventory_code = sourceLoc.subinventory_code (+) AND mmtt.organization_id = sourceLoc.organization_id (+) AND mmtt.transfer_to_location = destLoc.inventory_location_id (+) AND mmtt.transfer_subinventory = destLoc.subinventory_code (+) AND nvl(mmtt.transfer_organization, mmtt.organization_id) = destLoc.organization_id (+) AND moh.move_order_type IN (1,2) AND pickTypeLookup.lookup_type = 'INV_MOVE_ORDER_TYPE' AND pickTypeLookup.lookup_code = moh.move_order_type UNION ALL SELECT mmtt.pick_slip_line_number pick_slip_line , mmtt.pick_slip_number as pick_slip , NULL as pickwave_number , mmtt.organization_id , iop.organization_code as organization_code , esib.item_number as item , mmtt.revision , transaction_quantity as requested_quantity , txnUom.unit_of_measure as uom , secondary_transaction_quantity as secondary_requested_quantity , secondaryUom.unit_of_measure as secondary_uom , mmtt.subinventory_code as source_subinventory , mmtt.transaction_source_type_id , mmtt.transaction_type_id , mmtt.transaction_action_id , mmtt.locator_id as source_locator_id , Decode(mmtt.locator_id, null , null, FND_FLEX_EXT.GET_SEGS('INV','MTLL',sourceLoc.structure_instance_number,mmtt.locator_id,sourceLoc.subinventory_id)) AS source_locator , transfer_subinventory as destination_subinventory , DECODE(mmtt.transfer_to_location, null, null, FND_FLEX_EXT.GET_SEGS('INV','MTLL',destLoc.structure_instance_number,mmtt.transfer_to_location,destLoc.subinventory_id)) AS destination_locator , null as destination_account , wwo.work_order_number as order_number , wwo.work_order_number as source_order , to_char(wwop.operation_seq_number) as source_order_line , moh.request_number as movement_request , mol.line_number as movement_request_line , pickTypeLookup.meaning as pick_slip_type , NULL as shipment_number , NULL as shipping_method , NULL as shipping_priority , NULL as customer , NULL as ship_to_location_id , NULL AS ship_to_location_type , mol.DATE_REQUIRED as required_date , mol.date_required as due_date , ittv.transaction_type_name as transaction_type , mmtt.transaction_date , mmtt.transaction_temp_id transaction_id , mmtt.creation_date , mmtt.PROJECT_ID , mmtt.TASK_ID , mmtt.COUNTRY_OF_ORIGIN_CODE , NVL(esib.COMN_SUPPLY_PRJ_DEMAND_FLAG, 'Y') AS COMN_SUPPLY_PRJ_DEMAND_FLAG FROM inv_material_txns_temp mmtt , inv_txn_request_lines mol , inv_txn_request_headers moh , egp_system_items_b_v esib , inv_units_of_measure_vl txnUom , inv_units_of_measure_vl secondaryUom , inv_transaction_types_vl ittv , inv_item_locations sourceLoc , inv_item_locations destLoc , wie_work_orders_b wwo , WIE_WO_OPERATIONS_B wwop , fnd_lookups pickTypeLookup , inv_org_parameters iop WHERE mmtt.move_order_line_id = mol.line_id AND mmtt.transaction_type_id = mol.transaction_type_id AND moh.header_id = mol.header_id AND mmtt.organization_id = iop.organization_id AND mmtt.TRANSACTION_SOURCE_ID = wwo.work_order_id AND mmtt.trx_source_line_id = wwop.operation_seq_number AND wwo.work_order_id = wwop.work_order_id AND mmtt.inventory_item_id = esib.inventory_item_id AND mmtt.organization_id = esib.organization_id AND mmtt.transaction_uom = txnUom.uom_code AND mmtt.secondary_uom_code = secondaryUom.uom_code (+) AND mmtt.transaction_type_id = ittv.transaction_type_id AND mmtt.locator_id = sourceLoc.inventory_location_id (+) AND mmtt.subinventory_code = sourceLoc.subinventory_code (+) AND mmtt.organization_id = sourceLoc.organization_id (+) AND mmtt.transfer_to_location = destLoc.inventory_location_id (+) AND mmtt.transfer_subinventory = destLoc.subinventory_code (+) AND nvl(mmtt.transfer_organization, mmtt.organization_id) = destLoc.organization_id (+) AND moh.move_order_type = 5 AND pickTypeLookup.lookup_type = 'INV_MOVE_ORDER_TYPE' AND pickTypeLookup.lookup_code = moh.move_order_type