DBA Data[Home] [Help]

APPS.CTO_WORKBENCH_UTIL_PK dependencies on STANDARD

Line 149: --if (p_item_type in ('OPTION','STANDARD')) then

145: --
146: If (p_ato_line_id is not null) then
147:
148: --Adding INCLUDED item type code for SUN ER#9793792
149: --if (p_item_type in ('OPTION','STANDARD')) then
150: if (p_item_type in ('OPTION','STANDARD','INCLUDED')) then
151:
152: l_demand_line_id := p_line_id;
153:

Line 150: if (p_item_type in ('OPTION','STANDARD','INCLUDED')) then

146: If (p_ato_line_id is not null) then
147:
148: --Adding INCLUDED item type code for SUN ER#9793792
149: --if (p_item_type in ('OPTION','STANDARD')) then
150: if (p_item_type in ('OPTION','STANDARD','INCLUDED')) then
151:
152: l_demand_line_id := p_line_id;
153:
154: elsif (p_ato_line_id = p_line_id and p_item_type in ('MODEL', 'CLASS')) then

Line 503: --elsif p_ato_line_id is not null and p_item_type in ('STANDARD', 'OPTION') then

499: and oel.ato_line_id = p_ato_line_id
500: and oel.item_type_code = 'CONFIG';
501:
502: -- Added this condition for ATO Item ordered independently. Done as part of bugfix 8453372.
503: --elsif p_ato_line_id is not null and p_item_type in ('STANDARD', 'OPTION') then
504: --Adding INCLUDED item type code for SUN ER#9793792
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

Line 505: elsif p_ato_line_id is not null and p_item_type in ('STANDARD', 'OPTION', 'INCLUDED') then

501:
502: -- Added this condition for ATO Item ordered independently. Done as part of bugfix 8453372.
503: --elsif p_ato_line_id is not null and p_item_type in ('STANDARD', 'OPTION') then
504: --Adding INCLUDED item type code for SUN ER#9793792
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

Line 631: (p_item_type_code = 'STANDARD' OR

627:
628: ELSE
629:
630: IF p_ato_line_id = p_line_id AND
631: (p_item_type_code = 'STANDARD' OR
632: --Adding INCLUDED item type code for SUN ER#9793792
633: p_item_type_code = 'OPTION' OR
634: p_item_type_code = 'INCLUDED') THEN
635: