DBA Data[Home] [Help]

APPS.WSH_DOCUMENT_PUB dependencies on WSH_DOCUMENT_INSTANCES

Line 69: -- Merge Join Cartesian between wsh_document_instances and

65: )
66: IS
67:
68: -- bug 4891939, sql 15038246
69: -- Merge Join Cartesian between wsh_document_instances and
70: -- wsh_delivery_details due to decode in join condition.
71: -- document_csr is divided into two cursors document_csr_del
72: -- and document_csr_leg
73:

Line 144: wsh_document_instances doc

140: , doc.attribute13
141: , doc.attribute14
142: , doc.attribute15
143: FROM
144: wsh_document_instances doc
145: , wsh_delivery_details det
146: , wsh_delivery_assignments_v del
147: WHERE det.source_line_id = p_order_line_id
148: AND det.delivery_detail_id = del.delivery_detail_id

Line 225: wsh_document_instances doc

221: , doc.attribute13
222: , doc.attribute14
223: , doc.attribute15
224: FROM
225: wsh_document_instances doc
226: , wsh_delivery_details det
227: , wsh_delivery_assignments_v del
228: , wsh_delivery_legs leg
229: WHERE det.source_line_id = p_order_line_id