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.CTO_WIP_WRAPPER dependencies on STANDARD

Line 33: | item_type_code = 'Standard' and |

29: | to support ATO item under a PTO. |
30: | item_type_code for an ato item under PTO |
31: | is 'OPTION' and top_model_line_id will NOT be|
32: | null, UNLIKE an ato item order, where |
33: | item_type_code = 'Standard' and |
34: | top_model_lined_id is null |
35: | This fix has actually been provided in |
36: | branched code 115.15.1155.4 |
37: | |

Line 432: -- rkaza. 07/29/2005. bug 4438574. Item type code will be standard for

428: ' mtl_system_items MSI ';
429: end if;
430:
431:
432: -- rkaza. 07/29/2005. bug 4438574. Item type code will be standard for
433: -- independent ato item and option for ato under pto.
434:
435: sql_stmt := sql_stmt ||
436: 'where oel.inventory_item_id = msi.inventory_item_id '||

Line 438: 'and msi.bom_item_type = 4 '|| -- STANDARD

434:
435: sql_stmt := sql_stmt ||
436: 'where oel.inventory_item_id = msi.inventory_item_id '||
437: 'and oel.ship_from_org_id = msi.organization_id '||
438: 'and msi.bom_item_type = 4 '|| -- STANDARD
439: 'and oel.open_flag = ''Y'' '||
440: 'and oel.ato_line_id is not null '||
441: 'and (oel.item_type_code = ''CONFIG'' ' ||
442: 'or (oel.ato_line_id = oel.line_id ' ||

Line 448: 'and oel.item_type_code = ''STANDARD'' ' ||

444: --Adding INCLUDED item type code for SUN ER#9793792
445: 'or (oel.ato_line_id = oel.line_id ' ||
446: 'and oel.item_type_code = ''INCLUDED'') ' ||
447: 'or (oel.ato_line_id = oel.line_id ' ||
448: 'and oel.item_type_code = ''STANDARD'' ' ||
449: 'and oel.top_model_line_id is null)) ' ||
450: 'and nvl(oel.cancelled_flag, ''N'') = ''N'' '||
451: 'and oel.booked_flag = ''Y'' '||
452: 'and oel.schedule_status_code = ''SCHEDULED'' '||

Line 518: 'and oelc.item_type_code = ''STANDARD'' ' ||

514: ' from oe_order_lines_all oelc '||
515: ' where (oelc.ato_line_id = :l_line_id '||--5108885
516: 'and oelc.item_type_code = ''CONFIG'') '||
517: 'or (oelc.line_id = :l_line_id '||
518: 'and oelc.item_type_code = ''STANDARD'' ' ||
519: 'and oelc.top_model_line_id is null) '||
520: --Adding INCLUDED item type code for SUN ER#9793792
521: 'or (oelc.line_id = :l_line_id '||
522: 'and oelc.ato_line_id = oelc.line_id '||

Line 551: --'and oel.item_type_code in (''STANDARD'', ''OPTION'') '||

547: -- Given Load Type = 2: ATO items
548: --
549: sql_stmt := sql_stmt ||
550: --Adding INCLUDED item type code for SUN ER#9793792
551: --'and oel.item_type_code in (''STANDARD'', ''OPTION'') '||
552: 'and oel.item_type_code in (''STANDARD'', ''OPTION'', ''INCLUDED'') '||
553: 'and oel.ato_line_id = oel.line_id ';
554:
555: elsif (p_load_type = 3) then

Line 552: 'and oel.item_type_code in (''STANDARD'', ''OPTION'', ''INCLUDED'') '||

548: --
549: sql_stmt := sql_stmt ||
550: --Adding INCLUDED item type code for SUN ER#9793792
551: --'and oel.item_type_code in (''STANDARD'', ''OPTION'') '||
552: 'and oel.item_type_code in (''STANDARD'', ''OPTION'', ''INCLUDED'') '||
553: 'and oel.ato_line_id = oel.line_id ';
554:
555: elsif (p_load_type = 3) then
556: --

Line 562: --'or (oel.item_type_code in (''STANDARD'', ''OPTION'') '||

558: --
559: sql_stmt := sql_stmt ||
560: 'and (oel.item_type_code = ''CONFIG'' '||
561: --Adding INCLUDED item type code for SUN ER#9793792
562: --'or (oel.item_type_code in (''STANDARD'', ''OPTION'') '||
563: 'or (oel.item_type_code in (''STANDARD'', ''OPTION'', ''INCLUDED'') '||
564: 'and oel.ato_line_id = oel.line_id)) ';
565: end if;
566:

Line 563: 'or (oel.item_type_code in (''STANDARD'', ''OPTION'', ''INCLUDED'') '||

559: sql_stmt := sql_stmt ||
560: 'and (oel.item_type_code = ''CONFIG'' '||
561: --Adding INCLUDED item type code for SUN ER#9793792
562: --'or (oel.item_type_code in (''STANDARD'', ''OPTION'') '||
563: 'or (oel.item_type_code in (''STANDARD'', ''OPTION'', ''INCLUDED'') '||
564: 'and oel.ato_line_id = oel.line_id)) ';
565: end if;
566:
567: end if;

Line 755: -- the FND_WF_STANDARD.callback function at the end. This program tries to

751: if (lOperUnit <> WorkOrder_Rec.org_id ) then
752: --
753: -- Bugfix 2310559: We will call regular fnd_client_info.set_org_context instead of
754: -- OM's API Set_Created_By_Context because the conc programs submitted via WF, call
755: -- the FND_WF_STANDARD.callback function at the end. This program tries to
756: -- retrieve the value of the profile - CONC_REQUEST_ID but cannot find the
757: -- profile value as it was cleared during apps_initialize call. Thus resulting in
758: -- failures later.
759: --