eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_DOCUMENT_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 75


  SELECT
    doc.document_instance_id
  , doc.document_type
  , doc.entity_name
  , doc.entity_id
  , doc.doc_sequence_category_id
  , doc.sequence_number
  , doc.status
  , doc.final_print_date
/* Commented for Shipping Data Model Changes Bug#1918342
  , doc.pod_flag
  , doc.pod_by
  , doc.pod_date
  , doc.reason_of_transport
  , doc.description
  , doc.cod_amount
  , doc.cod_currency_code
  , doc.cod_remit_to
  , doc.cod_charge_paid_by
  , doc.problem_contact_reference
  , doc.bill_freight_to
  , doc.carried_by
  , doc.port_of_loading
  , doc.port_of_discharge
  , doc.booking_office
  , doc.booking_number
  , doc.service_contract
  , doc.shipper_export_ref
  , doc.carrier_export_ref
  , doc.bol_notify_party
  , doc.supplier_code
  , doc.aetc_number
  , doc.shipper_signed_by
  , doc.shipper_date
  , doc.carrier_signed_by
  , doc.carrier_date
  , doc.bol_issue_office
  , doc.bol_issued_by
  , doc.bol_date_issued
  , doc.shipper_hm_by
  , doc.shipper_hm_date
  , doc.carrier_hm_by
  , doc.carrier_hm_date*/
  , doc.created_by
  , doc.creation_date
  , doc.last_updated_by
  , doc.last_update_date
  , doc.last_update_login
  , doc.program_application_id
  , doc.program_id
  , doc.program_update_date
  , doc.request_id
  , doc.attribute_category
  , doc.attribute1
  , doc.attribute2
  , doc.attribute3
  , doc.attribute4
  , doc.attribute5
  , doc.attribute6
  , doc.attribute7
  , doc.attribute8
  , doc.attribute9
  , doc.attribute10
  , doc.attribute11
  , doc.attribute12
  , doc.attribute13
  , doc.attribute14
  , doc.attribute15
  FROM
    wsh_document_instances   doc
  , wsh_delivery_details     det
  , wsh_delivery_assignments_v del
  WHERE det.source_line_id = p_order_line_id
    AND det.delivery_detail_id = del.delivery_detail_id
    and det.container_flag = 'N'
    AND doc.entity_id = del.delivery_id
    AND doc.entity_name = 'WSH_NEW_DELIVERIES'
    AND nvl(det.LINE_DIRECTION , 'O') IN ('O', 'IO')   -- J Inbound Logistics jckwok
    AND doc.status = 'OPEN';

Line: 156


  SELECT
    doc.document_instance_id
  , doc.document_type
  , doc.entity_name
  , doc.entity_id
  , doc.doc_sequence_category_id
  , doc.sequence_number
  , doc.status
  , doc.final_print_date
/* Commented for Shipping Data Model Changes Bug#1918342
  , doc.pod_flag
  , doc.pod_by
  , doc.pod_date
  , doc.reason_of_transport
  , doc.description
  , doc.cod_amount
  , doc.cod_currency_code
  , doc.cod_remit_to
  , doc.cod_charge_paid_by
  , doc.problem_contact_reference
  , doc.bill_freight_to
  , doc.carried_by
  , doc.port_of_loading
  , doc.port_of_discharge
  , doc.booking_office
  , doc.booking_number
  , doc.service_contract
  , doc.shipper_export_ref
  , doc.carrier_export_ref
  , doc.bol_notify_party
  , doc.supplier_code
  , doc.aetc_number
  , doc.shipper_signed_by
  , doc.shipper_date
  , doc.carrier_signed_by
  , doc.carrier_date
  , doc.bol_issue_office
  , doc.bol_issued_by
  , doc.bol_date_issued
  , doc.shipper_hm_by
  , doc.shipper_hm_date
  , doc.carrier_hm_by
  , doc.carrier_hm_date*/
  , doc.created_by
  , doc.creation_date
  , doc.last_updated_by
  , doc.last_update_date
  , doc.last_update_login
  , doc.program_application_id
  , doc.program_id
  , doc.program_update_date
  , doc.request_id
  , doc.attribute_category
  , doc.attribute1
  , doc.attribute2
  , doc.attribute3
  , doc.attribute4
  , doc.attribute5
  , doc.attribute6
  , doc.attribute7
  , doc.attribute8
  , doc.attribute9
  , doc.attribute10
  , doc.attribute11
  , doc.attribute12
  , doc.attribute13
  , doc.attribute14
  , doc.attribute15
  FROM
    wsh_document_instances   doc
  , wsh_delivery_details     det
  , wsh_delivery_assignments_v del
  , wsh_delivery_legs        leg
  WHERE det.source_line_id = p_order_line_id
    AND det.delivery_detail_id = del.delivery_detail_id
    and det.container_flag = 'N'
    AND del.delivery_id = leg.delivery_id
    AND doc.entity_id = leg.delivery_leg_id
    AND doc.entity_name = 'WSH_DELIVERY_LEGS'
    AND nvl(det.LINE_DIRECTION , 'O') IN ('O', 'IO')   -- J Inbound Logistics jckwok
    AND doc.status = 'OPEN';