APPS.OE_INVOICE_PUB dependencies on WSH_DELIVERY_LEGS

Line 5761: FROM wsh_delivery_legs wdl,

5757: oe_debug_pub.add( 'POPULATING BILL OF LADING NUMBER ..' , 5 ) ;
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

Line 5763: where wdi.entity_name = 'WSH_DELIVERY_LEGS'

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'
5767: and rownum=1;

Line 5859: FROM wsh_delivery_legs wdl,

5855: oe_debug_pub.add( 'POPULATING BILL OF LADING NUMBER ..' , 5 ) ;
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

Line 5861: where wdi.entity_name = 'WSH_DELIVERY_LEGS'

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'
5865: and rownum=1;