APPS.RLM_PS_SV dependencies on RLM_SCHEDULE_LINES_ALL

Line 118: from rlm_schedule_headers rh, rlm_schedule_lines_all rl '

114: --
115: -- Final Queries
116: --
117: v_arch_statement := 'select distinct rh.header_id
118: from rlm_schedule_headers rh, rlm_schedule_lines_all rl '
119: || v_where_clause
120: || ' and rh.process_status = :k_ps_5'
121: || ' and rh.org_id = rl.org_id';
122:

Line 924: delete from rlm_schedule_lines_all

920: delete from rlm_interface_headers where header_id = v_sched_header_id;
921: --
922: --delete from archive as well
923: --
924: delete from rlm_schedule_lines_all
925: where header_id = (select header_id
926: from rlm_schedule_headers
927: where interface_header_id = v_sched_header_id);
928: --

Line 1493: rlm_schedule_lines_all scl

1489: --
1490: --Modified the code as per bugfix 6319027
1491: v_statement_oe :='select oe.open_flag, oe.header_id, oe.line_id ,oe.source_document_line_id, scl.line_number
1492: from oe_order_lines_all oe,
1493: rlm_schedule_lines_all scl
1494: where oe.header_id = scl.order_header_id
1495: and oe.source_document_line_id = scl.line_id
1496: and oe.source_document_type_id = 5
1497: and scl.header_id = :p_schedule_header_id' ;