DBA Data[Home] [Help]

APPS.OE_SHIPPING_INTEGRATION_PUB dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 48: from wf_item_activity_statuses wias,

44:
45:
46: select count(*)
47: into l_count
48: from wf_item_activity_statuses wias,
49: wf_process_activities wpa
50: where wias.item_type = 'OEOL'
51: and wias.item_key = to_char(p_line_id)
52: and wias.ACTIVITY_STATUS = 'NOTIFIED'

Line 1630: FROM wf_item_activity_statuses wias, wf_process_activities wpa

1626:
1627:
1628: SELECT 1
1629: INTO config_line_ship_notified
1630: FROM wf_item_activity_statuses wias, wf_process_activities wpa
1631: WHERE wias.item_type='OEOL'
1632: AND wias.item_key=l_config_line_id
1633: AND wpa.activity_name='SHIP_LINE'
1634: AND wias.activity_status='NOTIFIED'