APPS.OE_INVOICE_PUB dependencies on WSH_DELIVERY_LEGS

Line 6006: FROM wsh_delivery_legs wdl,

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

Line 6008: where wdi.entity_name = 'WSH_DELIVERY_LEGS'

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

Line 6104: FROM wsh_delivery_legs wdl,

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

Line 6106: where wdi.entity_name = 'WSH_DELIVERY_LEGS'

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