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.WIP_DIAG_DATA_COLL dependencies on WIP_PARAMETERS

Line 1675: 'from wip_parameters '||

1671: ' production_scheduler_id, '||
1672: ' decode(material_constrained,1,''Yes'',2,''No'') Material_Constrained, '||
1673: ' decode(use_finite_scheduler,1,''Yes'',2,''No'') Use_Finite_Scheduler,'||
1674: ' repetitive_variance_type '||
1675: 'from wip_parameters '||
1676: 'where organization_id = (select organization_id '||
1677: ' from wip_entities ';
1678:
1679:

Line 1685: 'WIP PARAMETERS',null,'Y',row_limit);

1681: sqltxt :=sqltxt||' where wip_entity_id = '|| p_wip_entity_id ||')';
1682: end if;
1683:
1684: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1685: 'WIP PARAMETERS',null,'Y',row_limit);
1686:
1687: IF (dummy_num = row_limit) THEN
1688: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1689: END IF;

Line 3856: 'from wip_parameters '||

3852: ' production_scheduler_id, '||
3853: ' decode(material_constrained,1,''Yes'',2,''No'') Material_Constrained, '||
3854: ' decode(use_finite_scheduler,1,''Yes'',2,''No'') Use_Finite_Scheduler,'||
3855: ' repetitive_variance_type '||
3856: 'from wip_parameters '||
3857: 'where organization_id = (select organization_id '||
3858: ' from wip_entities ';
3859:
3860:

Line 3866: 'WIP PARAMETERS',null,'Y',row_limit);

3862: sqltxt :=sqltxt||' where wip_entity_id = '|| p_wip_entity_id ||')';
3863: end if;
3864:
3865: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3866: 'WIP PARAMETERS',null,'Y',row_limit);
3867:
3868: IF (dummy_num = row_limit) THEN
3869: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3870: END IF;

Line 5013: from wip_parameters

5009: row_limit number;
5010:
5011: cursor wip_param_csr is
5012: select *
5013: from wip_parameters
5014: where organization_id = p_org_id ;
5015:
5016: wip_param_rec wip_param_csr%ROWTYPE ;
5017:

Line 5020: from wip_parameters_v

5016: wip_param_rec wip_param_csr%ROWTYPE ;
5017:
5018: cursor wip_param_v_csr is
5019: select *
5020: from wip_parameters_v
5021: where organization_id = p_org_id ;
5022:
5023: wip_param_v_rec wip_param_v_csr%ROWTYPE ;
5024:

Line 5311: 'wip_parameters_v wip1, ' ||

5307: 'mfg_lookups mlu6, ' ||
5308: 'mtl_parameters mtp, ' ||
5309: 'mtl_parameters mpm, ' ||
5310: 'mtl_parameters mpc, ' ||
5311: 'wip_parameters_v wip1, ' ||
5312: 'wip_parameters wip2, ' ||
5313: 'mtl_item_locations_kfv milk, ' ||
5314: 'gl_code_combinations_kfv gcck ' ||
5315: 'WHERE ' ||

Line 5312: 'wip_parameters wip2, ' ||

5308: 'mtl_parameters mtp, ' ||
5309: 'mtl_parameters mpm, ' ||
5310: 'mtl_parameters mpc, ' ||
5311: 'wip_parameters_v wip1, ' ||
5312: 'wip_parameters wip2, ' ||
5313: 'mtl_item_locations_kfv milk, ' ||
5314: 'gl_code_combinations_kfv gcck ' ||
5315: 'WHERE ' ||
5316: 'gcck.code_combination_id(+) = wip1.default_scrap_account_id AND ' ||

Line 5340: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'WIP Parameters SETUP',null,'Y',row_limit);

5336:
5337:
5338:
5339:
5340: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'WIP Parameters SETUP',null,'Y',row_limit);
5341:
5342: IF (dummy_num = row_limit) THEN
5343: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5344: END IF;

Line 5381: JTF_DIAGNOSTIC_COREAPI.ActionWarningLink('Parameters not set for average cost method. Please see the ', l_url, l_desc, ' for information on how to setup WIP parameters') ;

5377: wip_param_v_rec.system_option is null or
5378: wip_param_v_rec.cost_type is null or
5379: wip_param_v_rec.auto_compute_final_completion is null) then
5380:
5381: JTF_DIAGNOSTIC_COREAPI.ActionWarningLink('Parameters not set for average cost method. Please see the ', l_url, l_desc, ' for information on how to setup WIP parameters') ;
5382: end if ;
5383: end if;
5384: end if ;
5385: end checkWIPDetails ;

Line 5849: ' from wip_parameters'||

5845: ' default_overcompl_tolerance,'||
5846: ' production_scheduler_id,'||
5847: ' decode(material_constrained,1,''Yes'',2,''No'') Material_Constrained,'||
5848: ' decode(use_finite_scheduler,1,''Yes'',2,''No'') Use_Finite_Scheduler'||
5849: ' from wip_parameters'||
5850: ' where organization_id = ' || p_org_id ;
5851:
5852: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
5853: 'WIP Parameters SETUP');

Line 5853: 'WIP Parameters SETUP');

5849: ' from wip_parameters'||
5850: ' where organization_id = ' || p_org_id ;
5851:
5852: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
5853: 'WIP Parameters SETUP');
5854:
5855:
5856:
5857: */

Line 5869: JTF_DIAGNOSTIC_COREAPI.SectionPrint('Cost Group Setup for WIP Parameters') ;

5865: JTF_DIAGNOSTIC_COREAPI.SectionPrint('Item Attributes for Assemble To Order (ATO) discrete jobs') ;
5866: checkAtoAttributes ;
5867: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5868:
5869: JTF_DIAGNOSTIC_COREAPI.SectionPrint('Cost Group Setup for WIP Parameters') ;
5870: checkCostGroup ;
5871: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5872:
5873: JTF_DIAGNOSTIC_COREAPI.SectionPrint('Operation moves with Pending Move Transactions') ;