DBA Data[Home] [Help]

APPS.WSH_DOCUMENT_SETS dependencies on WSH_DOCUMENT_INSTANCES

Line 1143: FROM wsh_document_instances

1139: EXIT WHEN c_get_delivery_info%NOTFOUND;
1140:
1141: SELECT count(*)
1142: INTO l_bol_count
1143: FROM wsh_document_instances
1144: WHERE entity_name = 'WSH_DELIVERY_LEGS'
1145: AND entity_id = l_delivery_leg_id
1146: AND status <> 'CANCELLED';
1147:

Line 1216: from wsh_document_instances

1212: ELSIF document.concurrent_program_name = 'WSHRDPAK' THEN
1213:
1214: SELECT count(*)
1215: into cnt
1216: from wsh_document_instances
1217: WHERE entity_name = 'WSH_NEW_DELIVERIES'
1218: AND entity_id = l_argument(2)
1219: AND document_type = 'PACK_TYPE';
1220: