DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on WSH_DOCUMENT_INSTANCES

Line 6007: wsh_document_instances wdi

6003: END IF;
6004: SELECT wdi.sequence_number
6005: INTO p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE8
6006: FROM wsh_delivery_legs wdl,
6007: wsh_document_instances wdi
6008: where wdi.entity_name = 'WSH_DELIVERY_LEGS'
6009: and wdi.entity_id = wdl.delivery_leg_id
6010: and wdl.delivery_id =l_delivery_line_id
6011: and wdi.status <> 'CANCELLED'

Line 6105: wsh_document_instances wdi

6101: END IF;
6102: SELECT substr(wdi.sequence_number,1,30)
6103: INTO p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE8
6104: FROM wsh_delivery_legs wdl,
6105: wsh_document_instances wdi
6106: where wdi.entity_name = 'WSH_DELIVERY_LEGS'
6107: and wdi.entity_id = wdl.delivery_leg_id
6108: and wdl.delivery_id =l_delivery_line_id
6109: and wdi.status <> 'CANCELLED'