DBA Data[Home] [Help]

APPS.POR_RCV_ORD_SV dependencies on WF_ITEMS

Line 1979: po_distributions_all pod,wf_items wf

1975:
1976: cursor C1 is
1977: select distinct nvl(pod.wf_item_key,wf.ITEM_KEY)
1978: from rcv_transactions rcv,po_line_locations_all poll,
1979: po_distributions_all pod,wf_items wf
1980: where group_id = x_group_id and
1981: poll.line_location_id = rcv.po_line_location_id AND
1982: pod.po_distribution_id = rcv.po_distribution_id
1983: AND wf.item_type = 'PORCPT' AND

Line 2024: WF_ITEMS WI,

2020: --Bug 4999072 Changed the query to reduce the memory usage
2021: SELECT WIAS.ACTIVITY_STATUS
2022: INTO x_act_status
2023: FROM WF_ITEM_ACTIVITY_STATUSES WIAS,
2024: WF_ITEMS WI,
2025: WF_PROCESS_ACTIVITIES PA
2026: WHERE WIAS.ITEM_TYPE = wf_item_type
2027: AND WIAS.ITEM_KEY = wf_item_key
2028: AND WIAS.ITEM_TYPE = WI.ITEM_TYPE