DBA Data[Home] [Help]

APPS.CTO_WORKBENCH_UTIL_PK dependencies on OE_ORDER_LINES_ALL

Line 34: line_number oe_order_lines_all.line_number%type;

30: p_Component_Number IN NUMBER ,
31: p_Service_Number IN NUMBER
32: ) Return varchar2 IS
33: l_concat_value Varchar2(100);
34: line_number oe_order_lines_all.line_number%type;
35: shipment_number oe_order_lines_all.shipment_number%type;
36: option_number oe_order_lines_all.option_number%type;
37: component_number oe_order_lines_all.component_number%type;
38: service_number oe_order_lines_all.service_number%type;

Line 35: shipment_number oe_order_lines_all.shipment_number%type;

31: p_Service_Number IN NUMBER
32: ) Return varchar2 IS
33: l_concat_value Varchar2(100);
34: line_number oe_order_lines_all.line_number%type;
35: shipment_number oe_order_lines_all.shipment_number%type;
36: option_number oe_order_lines_all.option_number%type;
37: component_number oe_order_lines_all.component_number%type;
38: service_number oe_order_lines_all.service_number%type;
39:

Line 36: option_number oe_order_lines_all.option_number%type;

32: ) Return varchar2 IS
33: l_concat_value Varchar2(100);
34: line_number oe_order_lines_all.line_number%type;
35: shipment_number oe_order_lines_all.shipment_number%type;
36: option_number oe_order_lines_all.option_number%type;
37: component_number oe_order_lines_all.component_number%type;
38: service_number oe_order_lines_all.service_number%type;
39:
40: BEGIN

Line 37: component_number oe_order_lines_all.component_number%type;

33: l_concat_value Varchar2(100);
34: line_number oe_order_lines_all.line_number%type;
35: shipment_number oe_order_lines_all.shipment_number%type;
36: option_number oe_order_lines_all.option_number%type;
37: component_number oe_order_lines_all.component_number%type;
38: service_number oe_order_lines_all.service_number%type;
39:
40: BEGIN
41:

Line 38: service_number oe_order_lines_all.service_number%type;

34: line_number oe_order_lines_all.line_number%type;
35: shipment_number oe_order_lines_all.shipment_number%type;
36: option_number oe_order_lines_all.option_number%type;
37: component_number oe_order_lines_all.component_number%type;
38: service_number oe_order_lines_all.service_number%type;
39:
40: BEGIN
41:
42: If p_ato_line_id = p_line_id and p_item_type_code in ('MODEL','CLASS') then

Line 55: from oe_order_lines_all

51: shipment_number,
52: option_number,
53: component_number,
54: service_number
55: from oe_order_lines_all
56: where ato_line_id = p_ato_line_id
57: and item_type_code = 'CONFIG';
58:
59: EXCEPTION --- fp-J: added EXCEPTION block

Line 96: l_line_id oe_order_lines_all.line_id%type;

92: p_Ato_Line_Id IN NUMBER,
93: p_Item_Type_code IN Varchar2,
94: p_flow_status IN Varchar2) Return Varchar2 is
95: l_flow_status Varchar2(100):=null;
96: l_line_id oe_order_lines_all.line_id%type;
97: l_flow_status_code oe_order_lines_all.flow_status_code%type;
98: Begin
99:
100: l_flow_status := p_flow_status;

Line 97: l_flow_status_code oe_order_lines_all.flow_status_code%type;

93: p_Item_Type_code IN Varchar2,
94: p_flow_status IN Varchar2) Return Varchar2 is
95: l_flow_status Varchar2(100):=null;
96: l_line_id oe_order_lines_all.line_id%type;
97: l_flow_status_code oe_order_lines_all.flow_status_code%type;
98: Begin
99:
100: l_flow_status := p_flow_status;
101: if (p_Line_id = p_ato_line_id and p_item_type_code in ('MODEL', 'CLASS')) then

Line 107: from oe_order_lines_all oel

103: select line_id,
104: flow_status_code
105: into l_line_id,
106: l_flow_status_code
107: from oe_order_lines_all oel
108: where oel.ato_line_id = p_ato_line_id
109: and oel.item_type_code = 'CONFIG';
110: else
111:

Line 158: from oe_order_lines_all

154: elsif (p_ato_line_id = p_line_id and p_item_type in ('MODEL', 'CLASS')) then
155:
156: select line_id
157: into l_demand_line_id
158: from oe_order_lines_all
159: where ato_line_id = p_ato_line_id
160: and item_type_code = 'CONFIG';
161:
162: else

Line 374: l_config_line_id oe_order_lines_all.line_id%type;

370: Function Get_config_line_id (P_ato_line_id IN Number,
371: p_line_id IN Number,
372: p_item_type IN Varchar2) return number as
373:
374: l_config_line_id oe_order_lines_all.line_id%type;
375:
376: Begin
377: l_config_line_id := p_line_id;
378:

Line 394: from oe_order_lines_all

390: l_config_line_id := config_line_id_tbl(p_ato_line_id);
391: else
392: */
393: select line_id into l_config_line_id
394: from oe_order_lines_all
395: where ato_line_id = p_ato_line_id
396: and item_type_code = 'CONFIG';
397:
398: /*

Line 438: oe_order_lines_all oel

434:
435: select concatenated_segments
436: into l_item_name
437: from mtl_system_items_kfv mtl,
438: oe_order_lines_all oel
439: where oel.ato_line_id = p_ato_line_id
440: and oel.item_type_code = 'CONFIG'
441: and oel.inventory_item_id = mtl.inventory_item_id
442: and mtl.organization_id = p_ship_org_id;

Line 486: oe_order_lines_all oel

482: -- Changed this sql as part of bugfix 8453372. The sql now picks up data from tl table.
483: /*select description
484: into l_item_desc
485: from mtl_system_items_kfv mtl,
486: oe_order_lines_all oel
487: where mtl.inventory_item_id = oel.inventory_item_id
488: and mtl.organization_id = p_ship_org_id
489: and oel.ato_line_id = p_ato_line_id
490: and oel.item_type_code = 'CONFIG';*/

Line 495: oe_order_lines_all oel

491:
492: select description
493: into l_item_desc
494: from mtl_system_items_tl mtl,
495: oe_order_lines_all oel
496: where mtl.inventory_item_id = oel.inventory_item_id
497: and mtl.organization_id = p_ship_org_id
498: and mtl.language = userenv('LANG')
499: and oel.ato_line_id = p_ato_line_id

Line 509: oe_order_lines_all oel

505: elsif p_ato_line_id is not null and p_item_type in ('STANDARD', 'OPTION', 'INCLUDED') then
506: select description
507: into l_item_desc
508: from mtl_system_items_tl mtl,
509: oe_order_lines_all oel
510: where mtl.inventory_item_id = oel.inventory_item_id
511: and mtl.organization_id = p_ship_org_id
512: and oel.ato_line_id = p_ato_line_id
513: and mtl.language = userenv('LANG');

Line 528: from oe_order_headers_all h, oe_order_lines_all l

524: BEGIN
525:
526: select h.source_document_type_id
527: into l_source_document_type_id
528: from oe_order_headers_all h, oe_order_lines_all l
529: where h.header_id = l.header_id
530: and l.line_id = pLineId
531: and rownum = 1;
532:

Line 664: l_order_uom oe_order_lines_all.order_quantity_uom%type;

660: --l_prim_uom_code mtl_reservations.primary_uom_code%type;
661: l_line_id Number;
662:
663: --Bugfix 13554996: New variable and cursor.
664: l_order_uom oe_order_lines_all.order_quantity_uom%type;
665: l_item_id mtl_system_items_kfv.inventory_item_id%type;
666:
667: cursor c_on_hand_qty(x_line_id number, x_order_uom varchar2, x_item_id number) is
668: select CTO_UTILITY_PK.convert_uom

Line 687: from oe_order_lines_all

683: If p_ato_line_id is not null then
684: if p_ato_line_id = p_line_id and p_item_type_code in ('MODEL','CLASS') then
685: select line_id
686: into l_line_id
687: from oe_order_lines_all
688: where ato_line_id = p_ato_line_id
689: and item_type_code = 'CONFIG';
690: End if;
691: end if;

Line 711: from oe_order_lines_all oel

707: oel.order_quantity_uom,
708: nvl(l_prim_rsv_qty,0),
709: oel.inventory_item_id)
710: into l_rsv_qty
711: from oe_order_lines_all oel
712: where oel.line_id = l_line_id;
713: else
714: l_rsv_qty := 0;
715: End if;

Line 723: from oe_order_lines_all oel

719: select oel.order_quantity_uom,
720: oel.inventory_item_id
721: into l_order_uom,
722: l_item_id
723: from oe_order_lines_all oel
724: where oel.line_id = l_line_id;
725:
726: l_rsv_qty := 0;
727:

Line 891: from oe_order_lines_all

887: If p_ato_line_id is not null then
888: if p_ato_line_id = p_line_id and p_item_type_code in ('MODEL','CLASS') then
889: select line_id
890: into l_line_id
891: from oe_order_lines_all
892: where ato_line_id = p_ato_line_id
893: and item_type_code = 'CONFIG';
894: End if;
895: end if;

Line 913: from oe_order_lines_all oel

909: oel.order_quantity_uom,
910: nvl(l_prim_rsv_qty,0),
911: oel.inventory_item_id)
912: into l_rsv_qty
913: from oe_order_lines_all oel
914: where oel.line_id = l_line_id;
915: else
916: l_rsv_qty := 0;
917: End if;

Line 966: from oe_order_lines_all

962: x_config_line_id := config_line_id_tbl(p_ato_line_id);
963: else
964: */
965: select line_id into x_config_line_id
966: from oe_order_lines_all
967: where ato_line_id = p_ato_line_id
968: and item_type_code = 'CONFIG';
969:
970: /*