APPS.RLM_PS_SV dependencies on OE_ORDER_LINES_ALL

Line 69: FROM oe_order_lines_all

65: oe_demand ref_demand_cur;
66: --
67: CURSOR c IS
68: SELECT *
69: FROM oe_order_lines_all
70: WHERE line_id = v_order_line;
71: --
72: v_Sched_rec OE_ORDER_LINES_ALL%ROWTYPE;
73: --

Line 72: v_Sched_rec OE_ORDER_LINES_ALL%ROWTYPE;

68: SELECT *
69: FROM oe_order_lines_all
70: WHERE line_id = v_order_line;
71: --
72: v_Sched_rec OE_ORDER_LINES_ALL%ROWTYPE;
73: --
74: BEGIN
75: --
76: MO_GLOBAL.set_policy_context(p_access_mode => 'S',

Line 397: from oe_order_lines_all

393: oe_demand ref_demand_cur;
394: --
395: CURSOR c IS
396: select *
397: from oe_order_lines_all
398: where line_id = v_order_line;
399: --
400: v_Sched_rec OE_ORDER_LINES_ALL%ROWTYPE;
401: --

Line 400: v_Sched_rec OE_ORDER_LINES_ALL%ROWTYPE;

396: select *
397: from oe_order_lines_all
398: where line_id = v_order_line;
399: --
400: v_Sched_rec OE_ORDER_LINES_ALL%ROWTYPE;
401: --
402: BEGIN
403:
404: IF (l_debug <> -1) THEN

Line 780: from oe_order_lines_all

776: oe_demand ref_demand_cur;
777: --
778: CURSOR c IS
779: select *
780: from oe_order_lines_all
781: where line_id = v_order_line;
782: --
783: v_Sched_rec OE_ORDER_LINES_ALL%ROWTYPE;
784: --

Line 783: v_Sched_rec OE_ORDER_LINES_ALL%ROWTYPE;

779: select *
780: from oe_order_lines_all
781: where line_id = v_order_line;
782: --
783: v_Sched_rec OE_ORDER_LINES_ALL%ROWTYPE;
784: --
785: BEGIN
786: --
787: IF (l_debug <> -1) THEN

Line 1465: from oe_order_lines_all

1461: --
1462:
1463: CURSOR c IS
1464: select *
1465: from oe_order_lines_all
1466: where line_id = v_order_line;
1467: --
1468: v_Sched_rec OE_ORDER_LINES_ALL%ROWTYPE;
1469: --

Line 1468: v_Sched_rec OE_ORDER_LINES_ALL%ROWTYPE;

1464: select *
1465: from oe_order_lines_all
1466: where line_id = v_order_line;
1467: --
1468: v_Sched_rec OE_ORDER_LINES_ALL%ROWTYPE;
1469: --
1470:
1471:
1472: BEGIN

Line 1483: from oe_order_lines_all oe

1479:
1480: --
1481: /** Commented the code as per bugfix 6319027
1482: v_statement_oe :='select oe.open_flag, oe.header_id, oe.line_id ,oe.source_document_line_id
1483: from oe_order_lines_all oe
1484: where (oe.header_id,oe.source_document_id)
1485: IN ( select rlm.order_header_id,rlm.header_id
1486: from rlm_schedule_lines rlm
1487: where rlm.header_id = :p_schedule_header_id)';

Line 1492: from oe_order_lines_all oe,

1488: **/
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