APPS.CTO_TRANSFER_PRICE_PK dependencies on BOM_CTO_ORDER_LINES

Line 83: from bom_cto_order_lines

79:
80: BEGIN
81: /*select ato_line_id
82: into p_ato_line_id
83: from bom_cto_order_lines
84: where config_item_id = p_item_id
85: and rownum = 1;*/
86:
87: If p_line_id is null then

Line 90: from bom_cto_order_lines bcol

86:
87: If p_line_id is null then
88: select line_id
89: into l_line_id
90: from bom_cto_order_lines bcol
91: where config_item_id = p_item_id
92: and exists (select 'x'
93: from oe_order_lines_all oel
94: where oel.header_id = bcol.header_id

Line 220: from bom_cto_order_lines bcol

216: BEGIN
217: If p_line_id is null Then
218: select line_id
219: into l_line_id
220: from bom_cto_order_lines bcol
221: where config_item_id = p_item_id
222: and exists (select 'x'
223: from oe_order_lines_all oel
224: where oel.header_id = bcol.header_id

Line 477: bom_cto_order_lines bcol1 -- component

473: bcol1.line_id, -- line_id
474: bcol1.order_quantity_uom, --primary_uom_code
475: p_grp_id
476: from
477: bom_cto_order_lines bcol1 -- component
478: ,bom_cto_order_lines bcol2 -- parent model
479: where bcol1.parent_ato_line_id = p_line_id
480: and bcol1.parent_ato_line_id <> bcol1.line_id
481: and bcol2.line_id = p_line_id

Line 478: ,bom_cto_order_lines bcol2 -- parent model

474: bcol1.order_quantity_uom, --primary_uom_code
475: p_grp_id
476: from
477: bom_cto_order_lines bcol1 -- component
478: ,bom_cto_order_lines bcol2 -- parent model
479: where bcol1.parent_ato_line_id = p_line_id
480: and bcol1.parent_ato_line_id <> bcol1.line_id
481: and bcol2.line_id = p_line_id
482: UNION

Line 498: bom_cto_order_lines bcol1

494: bcol1.line_id, -- line_id
495: bcol1.order_quantity_uom, --primary_uom_code
496: p_grp_id
497: from
498: bom_cto_order_lines bcol1
499: where bcol1.line_id = p_line_id
500: ;
501:
502: lStmtNumber := 30;

Line 537: bom_cto_order_lines bcol1 -- component

533: bcol1.line_id, -- line_id
534: bcol1.order_quantity_uom, --primary_uom_code
535: p_grp_id
536: from
537: bom_cto_order_lines bcol1 -- component
538: ,bom_cto_order_lines bcol2 -- parent model
539: ,bom_explosion_temp bet
540: where bcol1.parent_ato_line_id = bet.line_id
541: and bcol2.line_id = bet.line_id

Line 538: ,bom_cto_order_lines bcol2 -- parent model

534: bcol1.order_quantity_uom, --primary_uom_code
535: p_grp_id
536: from
537: bom_cto_order_lines bcol1 -- component
538: ,bom_cto_order_lines bcol2 -- parent model
539: ,bom_explosion_temp bet
540: where bcol1.parent_ato_line_id = bet.line_id
541: and bcol2.line_id = bet.line_id
542: and bet.group_id = p_grp_id

Line 561: bom_cto_order_lines bcol1

557: bcol1.line_id, -- line_id
558: bcol1.order_quantity_uom, --primary_uom_code
559: p_grp_id
560: from
561: bom_cto_order_lines bcol1
562: ,bom_explosion_temp bet
563: where bcol1.line_id = bet.line_id
564: and bet.group_id = p_grp_id
565: and bet.sort_order = to_char(l_sort - 1)

Line 610: bom_cto_order_lines bcol1 -- component

606: bcol1.line_id, -- line_id
607: bcol1.order_quantity_uom, --primary_uom_code
608: p_grp_id
609: from
610: bom_cto_order_lines bcol1 -- component
611: ,bom_cto_order_lines bcol2 -- parent model
612: where bcol1.parent_ato_line_id = p_line_id
613: and bcol1.parent_ato_line_id <> bcol1.line_id
614: and bcol1.config_item_id is not null

Line 611: ,bom_cto_order_lines bcol2 -- parent model

607: bcol1.order_quantity_uom, --primary_uom_code
608: p_grp_id
609: from
610: bom_cto_order_lines bcol1 -- component
611: ,bom_cto_order_lines bcol2 -- parent model
612: where bcol1.parent_ato_line_id = p_line_id
613: and bcol1.parent_ato_line_id <> bcol1.line_id
614: and bcol1.config_item_id is not null
615: and bcol2.line_id = p_line_id

Line 653: bom_cto_order_lines bcol1 -- component

649: bcol1.line_id, -- line_id
650: bcol1.order_quantity_uom, --primary_uom_code
651: p_grp_id
652: from
653: bom_cto_order_lines bcol1 -- component
654: ,bom_cto_order_lines bcol2 -- parent model
655: ,bom_explosion_temp bet
656: where bcol1.parent_ato_line_id = bet.line_id
657: and bcol1.config_item_id is not null

Line 654: ,bom_cto_order_lines bcol2 -- parent model

650: bcol1.order_quantity_uom, --primary_uom_code
651: p_grp_id
652: from
653: bom_cto_order_lines bcol1 -- component
654: ,bom_cto_order_lines bcol2 -- parent model
655: ,bom_explosion_temp bet
656: where bcol1.parent_ato_line_id = bet.line_id
657: and bcol1.config_item_id is not null
658: and bcol2.line_id = bet.line_id