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 424: -- rkaza. 07/29/2005. bug 4438574. Item type code will be standard for

420: ' mtl_system_items MSI ';
421: end if;
422:
423:
424: -- rkaza. 07/29/2005. bug 4438574. Item type code will be standard for
425: -- independent ato item and option for ato under pto.
426:
427: sql_stmt := sql_stmt ||
428: 'where oel.inventory_item_id = msi.inventory_item_id '||

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

426:
427: sql_stmt := sql_stmt ||
428: 'where oel.inventory_item_id = msi.inventory_item_id '||
429: 'and oel.ship_from_org_id = msi.organization_id '||
430: 'and msi.bom_item_type = 4 '|| -- STANDARD
431: 'and oel.open_flag = ''Y'' '||
432: 'and oel.ato_line_id is not null '||
433: 'and (oel.item_type_code = ''CONFIG'' ' ||
434: 'or (oel.ato_line_id = oel.line_id ' ||

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

433: 'and (oel.item_type_code = ''CONFIG'' ' ||
434: 'or (oel.ato_line_id = oel.line_id ' ||
435: 'and oel.item_type_code = ''OPTION'') ' ||
436: 'or (oel.ato_line_id = oel.line_id ' ||
437: 'and oel.item_type_code = ''STANDARD'' ' ||
438: 'and oel.top_model_line_id is null)) ' ||
439: 'and nvl(oel.cancelled_flag, ''N'') = ''N'' '||
440: 'and oel.booked_flag = ''Y'' '||
441: 'and oel.schedule_status_code = ''SCHEDULED'' '||

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

494: ' from oe_order_lines_all oelc '||
495: ' where (oelc.ato_line_id = :l_line_id '||--5108885
496: 'and oelc.item_type_code = ''CONFIG'') '||
497: 'or (oelc.line_id = :l_line_id '||
498: 'and oelc.item_type_code = ''STANDARD'' ' ||
499: 'and oelc.top_model_line_id is null) '||
500: 'or (oelc.line_id = :l_line_id '|| -- ATO item within PTO
501: 'and oelc.ato_line_id = oelc.line_id '||
502: 'and oelc.item_type_code = ''OPTION'')) '; -- fix for bug#1874380

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

522: --
523: -- Given Load Type = 2: ATO items
524: --
525: sql_stmt := sql_stmt ||
526: 'and oel.item_type_code in (''STANDARD'', ''OPTION'') '||
527: 'and oel.ato_line_id = oel.line_id ';
528:
529: elsif (p_load_type = 3) then
530: --

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

531: -- Given Load Type = 3: Both Config and ATO items
532: --
533: sql_stmt := sql_stmt ||
534: 'and (oel.item_type_code = ''CONFIG'' '||
535: 'or (oel.item_type_code in (''STANDARD'', ''OPTION'') '||
536: 'and oel.ato_line_id = oel.line_id)) ';
537: end if;
538:
539: end if;

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

711: if (lOperUnit <> WorkOrder_Rec.org_id ) then
712: --
713: -- Bugfix 2310559: We will call regular fnd_client_info.set_org_context instead of
714: -- OM's API Set_Created_By_Context because the conc programs submitted via WF, call
715: -- the FND_WF_STANDARD.callback function at the end. This program tries to
716: -- retrieve the value of the profile - CONC_REQUEST_ID but cannot find the
717: -- profile value as it was cleared during apps_initialize call. Thus resulting in
718: -- failures later.
719: --