eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XDPCORE_OM dependencies on OE_ORDER_LINES_ALL

Line 358: FROM oe_order_lines_all l,

354: l_item_key := l_line_id ;
355:
356: SELECT NVL(l.org_id,h.org_id), h.order_number
357: INTO l_org_id,l_order_number
358: FROM oe_order_lines_all l,
359: oe_order_headers_all h
360: WHERE l.line_id = to_number(l_line_id)
361: AND l.header_id = h.header_id ;
362:

Line 421: FROM oe_order_lines_all l

417:
418: CURSOR c_lines(p_header_id NUMBER) IS
419: SELECT line_id ,
420: flow_status_code
421: FROM oe_order_lines_all l
422: WHERE l.header_id = p_header_id ;
423:
424: BEGIN
425:

Line 627: FROM oe_order_lines_all l

623: l.configuration_id,
624: l.config_header_id,
625: l.config_rev_nbr,
626: l.sort_order
627: FROM oe_order_lines_all l
628: WHERE l.header_id = p_header_id
629: AND l.link_to_line_id IS NULL
630: ORDER BY l.line_number ;
631:

Line 648: FROM oe_order_lines_all l

644: l.configuration_id,
645: l.config_header_id,
646: l.config_rev_nbr,
647: l.sort_order
648: FROM oe_order_lines_all l
649: WHERE l.header_id = p_header_id
650: AND l.top_model_line_id = p_top_line_id
651: AND l.link_to_line_id IS NOT NULL
652: AND l.line_id <> p_top_line_id

Line 659: l_prev_sort_order OE_ORDER_LINES_ALL.SORT_ORDER%TYPE ;

655:
656: l_init_seq NUMBER := 10 ;
657: l_next_seq NUMBER := 0 ;
658: l_seq NUMBER := 0;
659: l_prev_sort_order OE_ORDER_LINES_ALL.SORT_ORDER%TYPE ;
660: l_line_count NUMBER := 0;
661: l_line_type VARCHAR2(40) ;
662:
663: BEGIN

Line 674: g_order_line_list(l_line_count).line_source := 'OE_ORDER_LINES_ALL' ;

670:
671: -- The top line is not a package and needs activation.
672:
673: g_order_line_list(l_line_count).line_number := c_top_rec.line_id ;
674: g_order_line_list(l_line_count).line_source := 'OE_ORDER_LINES_ALL' ;
675: g_order_line_list(l_line_count).inventory_item_id := c_top_rec.inventory_item_id ;
676: g_order_line_list(l_line_count).action_code := c_top_rec.line_type_id ;
677: g_order_line_list(l_line_count).organization_id := c_top_rec.ship_from_org_id ;
678: g_order_line_list(l_line_count).ib_source := 'TXN' ;

Line 708: g_order_line_list(l_line_count).line_source := 'OE_ORDER_LINES_ALL' ;

704: l_prev_sort_order := c_child_rec.sort_order ;
705: END IF ;
706:
707: g_order_line_list(l_line_count).line_number := c_child_rec.line_id ;
708: g_order_line_list(l_line_count).line_source := 'OE_ORDER_LINES_ALL' ;
709: g_order_line_list(l_line_count).inventory_item_id := c_child_rec.inventory_item_id ;
710: g_order_line_list(l_line_count).action_code := c_child_rec.line_type_id ;
711: g_order_line_list(l_line_count).organization_id := c_child_rec.ship_from_org_id ;
712: g_order_line_list(l_line_count).ib_source := 'TXN' ;

Line 938: FROM oe_order_lines_all l ,

934: h.header_id
935: INTO l_order_number ,
936: l_order_version ,
937: l_header_id
938: FROM oe_order_lines_all l ,
939: oe_order_headers_all h
940: WHERE l.line_id = l_line_id
941: AND l.header_id = h.header_id ;
942:

Line 1044: FROM oe_order_lines_all l ,

1040: h.header_id
1041: INTO l_order_number ,
1042: l_order_version ,
1043: l_header_id
1044: FROM oe_order_lines_all l ,
1045: oe_order_headers_all h
1046: WHERE l.line_id = l_line_id
1047: AND l.header_id = h.header_id ;
1048: