971: , To_number(NULL)
972: , To_char(NULL)
973: , To_char(NULL)
974: FROM oe_order_lines_all oel
975: , oe_order_headers_all oeh
976: --, wf_item_activity_statuses wf
977: --, wf_process_activities wpa
978: WHERE oel.header_id = oeh.header_id
979: AND oel.header_id = v_oe_order_header_id
1014: ,v_task_id NUMBER)
1015: IS
1016: SELECT COUNT(*)
1017: FROM oe_order_lines_all oel
1018: , oe_order_headers_all oeh
1019: --, wf_item_activity_statuses wf
1020: --, wf_process_activities wpa
1021: WHERE oel.header_id = oeh.header_id
1022: AND oel.header_id = v_oe_order_header_id