1. Tables and Views for SCM
  2. DOO_ORDER_FLINE_PTASKS_V

DOO_ORDER_FLINE_PTASKS_V

Details

  • Schema: FUSION

  • Object owner: DOO

  • Object type: VIEW

Columns

Name

FULFILL_LINE_ID

FULFILL_LINE_NUMBER

LINE_ID

HEADER_ID

OBJECT_VERSION_NUMBER

STATUS_CODE

OWNER_ID

SOURCE_LINE_ID

SOURCE_LINE_NUMBER

SOURCE_ORDER_ID

SOURCE_ORDER_NUMBER

SOURCE_ORDER_SYSTEM

SOURCE_SCHEDULE_ID

SOURCE_SCHEDULE_NUMBER

INVENTORY_ITEM_ID

ITEM_TYPE_CODE

FULFILL_ORG_ID

ORDERED_QTY

ORDERED_UOM

RMA_DELIVERED_QTY

FULFILLED_QTY

SHIPPED_QTY

RESERVED_QTY

RESERVABLE_FLAG

SHIPPABLE_FLAG

INVOICEABLE_ITEM_FLAG

INVOICE_ENABLED_FLAG

BILL_TO_CONTACT_ID

BILL_TO_CUSTOMER_ID

BILL_TO_SITE_USE_ID

SOURCE_ORG_ID

ORG_ID

REQUEST_ARRIVAL_DATE

REQUEST_SHIP_DATE

SCHEDULE_ARRIVAL_DATE

SCHEDULE_SHIP_DATE

PROMISE_ARRIVAL_DATE

PROMISE_SHIP_DATE

ACTUAL_SHIP_DATE

FULFILLMENT_DATE

CUSTOMER_ITEM_ID

CUSTOMER_PO_LINE_NUMBER

CUSTOMER_PO_NUMBER

DEMAND_CLASS_CODE

EXTENDED_AMOUNT

FOB_POINT_CODE

CARRIER_ID

INVOICING_RULE_ID

EXEMPTION_CERTIFICATE_NUMBER

ACCOUNTING_RULE_ID

LINE_TYPE_CODE

CATEGORY_CODE

OPEN_FLAG

CANCELED_FLAG

OVERRIDE_SCHEDULE_DATE_FLAG

ORIGINAL_INVENTORY_ITEM_ID

GOP_REFERENCE_ID

PACKING_INSTRUCTIONS

PARENT_FULFILL_LINE_ID

PAYMENT_TERM_ID

REQUEST_TYPE

RETURN_REASON_CODE

ORIG_SYS_DOCUMENT_REF

ORIG_SYS_DOCUMENT_LINE_REF

ROOT_PARENT_FULFILL_LINE_ID

SHIP_CLASS_OF_SERVICE

SHIP_MODE_OF_TRANSPORT

SHIP_TO_CONTACT_ID

SHIP_TO_CUSTOMER_ID

SHIP_TO_SITE_USE_ID

FULFILL_TOLERANCE_ABOVE

FULFILL_TOLERANCE_BELOW

SHIPMENT_PRIORITY_CODE

SHIPPING_INSTRUCTIONS

SHIP_SET_NAME

SPLIT_FROM_FLINE_ID

PARTIAL_SHIP_ALLOWED_FLAG

SUBSTITUTE_ALLOWED_FLAG

SUBSTITUTE_REASON_CODE

TAX_EXEMPT_FLAG

TAX_CLASSIFICATION_CODE

TAX_EXEMPTION_REASON_CODE

UNIT_LIST_PRICE

UNIT_SELLING_PRICE

LATEST_ACCEPTABLE_SHIP_DATE

LATEST_ACCEPTABLE_ARRIVAL_DATE

EARLIEST_ACCEPTABLE_SHIP_DATE

CANCELED_QTY

RETURNABLE_FLAG

DELTA_TYPE

REFERENCE_FLINE_ID

REMNANT_FLAG

ON_HOLD

RESERVATION_ID

ACTUAL_COMPLETION_DATE

INVENTORY_ORGANIZATION_ID

FULFILL_INSTANCE_ID

FULFILLMENT_SPLIT_REF_ID

ESTIMATE_MARGIN

ESTIMATE_FULFILLMENT_COST

COMP_SEQ_PATH

STATUS_RULESET_ID

INVOICE_INTERFACED_FLAG

PRIMARY_TASK_STATUS

SOURCE_REVISION_NUMBER

FREIGHT_TERMS_CODE

CANCEL_REASON_CODE

LATEST_EXT_FULFILL_LINE_NUMBER

GOP_REQUEST_REGION

SCHEDULING_REASON_CODE

SUBINVENTORY

SHIP_TO_PARTY_ID

SHIP_TO_PARTY_CONTACT_ID

SHIP_TO_PARTY_SITE_ID

RECEIVABLES_ORG_ID

REQUEST_CANCEL_DATE

COMMENTS

REQUIRED_FULFILLMENT_DATE

Query

SQL_Statement

SELECT

flin.FULFILL_LINE_ID,

flin.FULFILL_LINE_NUMBER,

flin.LINE_ID,

flin.HEADER_ID,

flin.OBJECT_VERSION_NUMBER,

flin.STATUS_CODE,

flin.OWNER_ID,

flin.SOURCE_LINE_ID,

flin.SOURCE_LINE_NUMBER,

flin.SOURCE_ORDER_ID,

flin.SOURCE_ORDER_NUMBER,

flin.SOURCE_ORDER_SYSTEM,

flin.SOURCE_SCHEDULE_ID,

flin.SOURCE_SCHEDULE_NUMBER,

flin.INVENTORY_ITEM_ID,

flin.ITEM_TYPE_CODE,

flin.FULFILL_ORG_ID,

flin.ORDERED_QTY,

flin.ORDERED_UOM,

flin.RMA_DELIVERED_QTY,

flin.FULFILLED_QTY,

flin.SHIPPED_QTY,

flin.RESERVED_QTY,

flin.RESERVABLE_FLAG,

flin.SHIPPABLE_FLAG,

flin.INVOICEABLE_ITEM_FLAG,

flin.INVOICE_ENABLED_FLAG,

flin.BILL_TO_CONTACT_ID,

flin.BILL_TO_CUSTOMER_ID,

flin.BILL_TO_SITE_USE_ID,

flin.SOURCE_ORG_ID,

flin.ORG_ID,

flin.REQUEST_ARRIVAL_DATE,

flin.REQUEST_SHIP_DATE,

flin.SCHEDULE_ARRIVAL_DATE,

flin.SCHEDULE_SHIP_DATE,

flin.PROMISE_ARRIVAL_DATE,

flin.PROMISE_SHIP_DATE,

flin.ACTUAL_SHIP_DATE,

flin.FULFILLMENT_DATE,

flin.CUSTOMER_ITEM_ID,

flin.CUSTOMER_PO_LINE_NUMBER,

flin.CUSTOMER_PO_NUMBER,

flin.DEMAND_CLASS_CODE,

flin.EXTENDED_AMOUNT,

flin.FOB_POINT_CODE,

flin.CARRIER_ID,

flin.INVOICING_RULE_ID,

flin.EXEMPTION_CERTIFICATE_NUMBER,

flin.ACCOUNTING_RULE_ID,

flin.LINE_TYPE_CODE,

flin.CATEGORY_CODE,

flin.OPEN_FLAG,

flin.CANCELED_FLAG,

flin.OVERRIDE_SCHEDULE_DATE_FLAG,

flin.ORIGINAL_INVENTORY_ITEM_ID,

flin.GOP_REFERENCE_ID,

flin.PACKING_INSTRUCTIONS,

flin.PARENT_FULFILL_LINE_ID,

flin.PAYMENT_TERM_ID,

flin.REQUEST_TYPE,

flin.RETURN_REASON_CODE,

flin.ORIG_SYS_DOCUMENT_REF,

flin.ORIG_SYS_DOCUMENT_LINE_REF,

flin.ROOT_PARENT_FULFILL_LINE_ID,

flin.SHIP_CLASS_OF_SERVICE,

flin.SHIP_MODE_OF_TRANSPORT,

flin.SHIP_TO_CONTACT_ID,

flin.SHIP_TO_CUSTOMER_ID,

flin.SHIP_TO_SITE_USE_ID,

flin.FULFILL_TOLERANCE_ABOVE,

flin.FULFILL_TOLERANCE_BELOW,

flin.SHIPMENT_PRIORITY_CODE,

flin.SHIPPING_INSTRUCTIONS,

flin.SHIP_SET_NAME,

flin.SPLIT_FROM_FLINE_ID,

flin.PARTIAL_SHIP_ALLOWED_FLAG,

flin.SUBSTITUTE_ALLOWED_FLAG,

flin.SUBSTITUTE_REASON_CODE,

flin.TAX_EXEMPT_FLAG,

flin.TAX_CLASSIFICATION_CODE,

flin.TAX_EXEMPTION_REASON_CODE,

flin.UNIT_LIST_PRICE,

flin.UNIT_SELLING_PRICE,

flin.LATEST_ACCEPTABLE_SHIP_DATE,

flin.LATEST_ACCEPTABLE_ARRIVAL_DATE,

flin.EARLIEST_ACCEPTABLE_SHIP_DATE,

flin.CANCELED_QTY,

flin.RETURNABLE_FLAG,

flin.DELTA_TYPE,

flin.REFERENCE_FLINE_ID,

flin.REMNANT_FLAG,

flin.ON_HOLD,

flin.RESERVATION_ID,

flin.ACTUAL_COMPLETION_DATE,

flin.INVENTORY_ORGANIZATION_ID,

flin.FULFILL_INSTANCE_ID,

flin.FULFILLMENT_SPLIT_REF_ID,

flin.ESTIMATE_MARGIN,

flin.ESTIMATE_FULFILLMENT_COST,

flin.COMP_SEQ_PATH,

flin.STATUS_RULESET_ID,

flin.INVOICE_INTERFACED_FLAG,

ptask.status_code PRIMARY_TASK_STATUS,

flin.SOURCE_REVISION_NUMBER,

flin.FREIGHT_TERMS_CODE,

flin.CANCEL_REASON_CODE,

flin.LATEST_EXT_FULFILL_LINE_NUMBER,

flin.GOP_REQUEST_REGION,

flin.SCHEDULING_REASON_CODE,

flin.SUBINVENTORY,

flin.SHIP_TO_PARTY_ID,

flin.SHIP_TO_PARTY_CONTACT_ID,

flin.SHIP_TO_PARTY_SITE_ID,

flin.RECEIVABLES_ORG_ID,

flin.REQUEST_CANCEL_DATE,

flin.COMMENTS,

flin.REQUIRED_FULFILLMENT_DATE

FROM

DOO_FULFILL_LINES_ALL flin, doo_orchestration_groups grp,doo_task_instances ptask

where flin.fulfill_line_id=grp.fulfillment_line_id

and grp.doo_process_instance_id = ptask.doo_process_instance_id

and ptask.actual_start_date<=sysdate and ptask.actual_completion_date is null