Aktualizacja kontekstu na liniach wysyłek:
Select wdd.rowid, wdd.attribute_category, SOURCE_HEADER_NUMBER from wsh_delivery_details wdd, wsh_delivery_assignments wda, fnd_lookup_values flv_source, fnd_lookup_values flv_released WHERE wda.delivery_detail_id = wdd.delivery_detail_id and flv_source.lookup_type = 'SOURCE_SYSTEM' and flv_source.lookup_code = wdd.source_code and flv_released.lookup_type = 'PICK_STATUS' and flv_released.lookup_code = wdd.released_status and nvl(wdd.line_direction, 'O') IN ('O', 'IO') and flv_source.LANGUAGE = userenv('LANG') and flv_source.VIEW_APPLICATION_ID = 665 and flv_source.SECURITY_GROUP_ID = 0 and flv_released.LANGUAGE = userenv('LANG') and flv_released.VIEW_APPLICATION_ID = 665 and flv_released.SECURITY_GROUP_ID = 0 and SOURCE_HEADER_NUMBER in (&Numer_ZS)
Dostawa
select t.rowid, t.* from wsh_new_deliveries t where t.name = '&Nazwa_dostawy'