DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on WSH_DOCUMENT_INSTANCES

Line 5762: wsh_document_instances wdi

5758: END IF;
5759: SELECT wdi.sequence_number
5760: INTO p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE8
5761: FROM wsh_delivery_legs wdl,
5762: wsh_document_instances wdi
5763: where wdi.entity_name = 'WSH_DELIVERY_LEGS'
5764: and wdi.entity_id = wdl.delivery_leg_id
5765: and wdl.delivery_id =l_delivery_line_id
5766: and wdi.status <> 'CANCELLED'

Line 5860: wsh_document_instances wdi

5856: END IF;
5857: SELECT substr(wdi.sequence_number,1,30)
5858: INTO p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE8
5859: FROM wsh_delivery_legs wdl,
5860: wsh_document_instances wdi
5861: where wdi.entity_name = 'WSH_DELIVERY_LEGS'
5862: and wdi.entity_id = wdl.delivery_leg_id
5863: and wdl.delivery_id =l_delivery_line_id
5864: and wdi.status <> 'CANCELLED'