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 1456: from oe_order_lines_all

1452: --
1453:
1454: CURSOR c IS
1455: select *
1456: from oe_order_lines_all
1457: where line_id = v_order_line;
1458: --
1459: v_Sched_rec OE_ORDER_LINES_ALL%ROWTYPE;
1460: --

Line 1459: v_Sched_rec OE_ORDER_LINES_ALL%ROWTYPE;

1455: select *
1456: from oe_order_lines_all
1457: where line_id = v_order_line;
1458: --
1459: v_Sched_rec OE_ORDER_LINES_ALL%ROWTYPE;
1460: --
1461:
1462:
1463: BEGIN

Line 1474: from oe_order_lines_all oe

1470:
1471: --
1472: /** Commented the code as per bugfix 6319027
1473: v_statement_oe :='select oe.open_flag, oe.header_id, oe.line_id ,oe.source_document_line_id
1474: from oe_order_lines_all oe
1475: where (oe.header_id,oe.source_document_id)
1476: IN ( select rlm.order_header_id,rlm.header_id
1477: from rlm_schedule_lines rlm
1478: where rlm.header_id = :p_schedule_header_id)';

Line 1483: from oe_order_lines_all oe,

1479: **/
1480: --
1481: --Modified 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, scl.line_number
1483: from oe_order_lines_all oe,
1484: rlm_schedule_lines_all scl
1485: where oe.header_id = scl.order_header_id
1486: and oe.source_document_line_id = scl.line_id
1487: and oe.source_document_type_id = 5