DBA Data[Home] [Help]

APPS.OKE_BILLING_EVENT_PUB dependencies on WSH_DELIVERY_LEGS

Line 1222: , wsh_delivery_legs dl

1218:
1219: CURSOR BillLading ( C_Deliverable_ID NUMBER ) IS
1220: SELECT di.sequence_number
1221: FROM wsh_document_instances di
1222: , wsh_delivery_legs dl
1223: , wsh_delivery_details dd
1224: , wsh_delivery_assignments da
1225: WHERE dd.source_code = 'OKE'
1226: AND dd.source_line_id = C_Deliverable_ID

Line 1230: AND di.entity_name = 'WSH_DELIVERY_LEGS'

1226: AND dd.source_line_id = C_Deliverable_ID
1227: AND da.delivery_detail_id = dd.delivery_detail_id
1228: AND dl.delivery_id = da.delivery_id
1229: AND di.entity_id = dl.delivery_leg_id
1230: AND di.entity_name = 'WSH_DELIVERY_LEGS'
1231: AND di.status <> 'CANCELED';
1232:
1233:
1234: Cursor Can_qty_c(p_deliverable_id number) is