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_ENTITIES

Line 74: ' from wip_discrete_jobs a , wip_entities b, mtl_system_items_kfv m, mtl_parameters p ' ||

70: ' decode(a.overcompletion_tolerance_type, ' ||
71: ' 1, ''Percent'', ' ||
72: ' 2, ''Amount'') Tol_Type, ' ||
73: ' a.overcompletion_tolerance_value Tol_Value ' ||
74: ' from wip_discrete_jobs a , wip_entities b, mtl_system_items_kfv m, mtl_parameters p ' ||
75: ' where b.wip_entity_id = a.wip_entity_id ' ||
76: ' and b.organization_id = a.organization_id ' ||
77: ' and m.inventory_item_id = a.primary_item_id ' ||
78: ' and m.organization_id = a.organization_id ' ||

Line 86: 'JOB HEADER ( WIP DISCRETE JOBS , WIP ENTITIES )',null,'Y',row_limit);

82: sqltxt :=sqltxt||' and b.wip_entity_id = '|| p_wip_entity_id;
83: end if;
84:
85: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
86: 'JOB HEADER ( WIP DISCRETE JOBS , WIP ENTITIES )',null,'Y',row_limit);
87:
88: IF (dummy_num = row_limit) THEN
89: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
90: END IF;

Line 119: 'from wip_operations a, wip_entities b, bom_departments c, bom_standard_operations bso ' ||

115: ' 2, ''No'') backflush_flag, ' ||
116: ' a.minimum_transfer_quantity, ' ||
117: ' a.date_last_moved, ' ||
118: ' a.creation_date ' ||
119: 'from wip_operations a, wip_entities b, bom_departments c, bom_standard_operations bso ' ||
120: 'where a.wip_entity_id = b.wip_entity_id ' ||
121: 'and a.organization_id = b.organization_id ' ||
122: 'and a.department_id = c.department_id ' ||
123: 'and a.organization_id = c.organization_id ' ||

Line 164: 'from wip_requirement_operations a, wip_entities b, mtl_system_items_kfv m '||

160: ' a.quantity_allocated, '||
161: ' a.quantity_backordered, '||
162: ' a.quantity_relieved, '||
163: ' a.creation_date '||
164: 'from wip_requirement_operations a, wip_entities b, mtl_system_items_kfv m '||
165: 'where b.wip_entity_id = a.wip_entity_id '||
166: 'and b.organization_id = a.organization_id '||
167: 'and a.inventory_item_id = m.inventory_item_id '||
168: 'and a.organization_id = m.organization_id ';

Line 338: ' from wip_entities we '||

334: ' wmt.batch_id, ' ||
335: ' wmt.scrap_account_id '||
336: 'from wip_move_transactions wmt '||
337: 'where exists (select 1 '||
338: ' from wip_entities we '||
339: ' where we.wip_entity_id = wmt.wip_entity_id '||
340: ' and we.entity_type <> 2 '|| /* Other than repetitive Schedule */
341: ' ) ';
342:

Line 558: ' from wip_entities we '||

554: ' wt.move_transaction_id, '||
555: ' wt.completion_transaction_id '||
556: 'from wip_transactions wt '||
557: 'where exists (select 1 '||
558: ' from wip_entities we '||
559: ' where we.wip_entity_id = wt.wip_entity_id '||
560: ' and we.entity_type <> 2) '; /* Other than Repetitive */
561:
562: if p_wip_entity_id is not null then

Line 928: ' wip_entities we, '||

924: 'WHERE trl.move_order_type <> 6 '||
925: 'AND (trl.txn_source_id, trl.txn_source_line_id) in '||
926: ' (select wdj.wip_entity_id, wro.operation_seq_num '||
927: ' from wip_discrete_jobs wdj, '||
928: ' wip_entities we, '||
929: ' wip_lines wl, '||
930: ' wip_requirement_operations wro '||
931: ' where wdj.wip_entity_id = we.wip_entity_id '||
932: ' and wdj.organization_id = we.organization_id '||

Line 1015: ' from wip_entities '||

1011: ' error_code '||
1012: 'from mtl_material_transactions '||
1013: 'where transaction_source_type_id = 5 '||
1014: 'and exists (select 1 '||
1015: ' from wip_entities '||
1016: ' where wip_entity_id = transaction_source_id '||
1017: ' and entity_type <> 2 ) '; /* Other than repetitive schedule */
1018:
1019: if p_wip_entity_id is not null then

Line 1241: ' WIP_ENTITIES WE, '||

1237: ' to_char(RES.CREATION_DATE, ''DD-MON HH24:MI:SS'') CREATE_DATE, '||
1238: ' to_char(RES.LAST_UPDATE_DATE, ''DD-MON HH24:MI:SS'') UPD_DATE '||
1239: 'from '||
1240: ' MTL_RESERVATIONS RES, '||
1241: ' WIP_ENTITIES WE, '||
1242: ' WIP_DISCRETE_JOBS JOB '||
1243: 'where RES.SUPPLY_SOURCE_HEADER_ID = WE.WIP_ENTITY_ID '||
1244: 'and WE.WIP_ENTITY_ID = JOB.WIP_ENTITY_ID ';
1245:

Line 1677: ' from wip_entities ';

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:
1680: if p_wip_entity_id is not null then
1681: sqltxt :=sqltxt||' where wip_entity_id = '|| p_wip_entity_id ||')';

Line 1855: ' from wip_entities ';

1851: ' picking_order, '||
1852: ' source_subinventory '||
1853: 'from mtl_secondary_inventories '||
1854: 'where organization_id = (select organization_id '||
1855: ' from wip_entities ';
1856:
1857:
1858: if p_wip_entity_id is not null then
1859: sqltxt :=sqltxt||' where wip_entity_id = '|| p_wip_entity_id ||')';

Line 1874: from wip_entities

1870: -- Run following diagnostics only for Lot Based jobs
1871: begin
1872: select 1
1873: into l_dummy
1874: from wip_entities
1875: where wip_entity_id = p_wip_entity_id
1876: and entity_type = 5 ; -- LotBased
1877:
1878: sqltxt := ' select ' ||

Line 1892: ' from wsm_parameters wp, wip_entities we ' ||

1888: ' , estimated_scrap_accounting ' ||
1889: ' , inv_lot_txn_enabled ' ||
1890: ' , honor_kanban_size ' ||
1891: ' , charge_jump_from_queue ' ||
1892: ' from wsm_parameters wp, wip_entities we ' ||
1893: ' where wp.organization_id = we.organization_id' ||
1894: ' and we.wip_entity_id = ' || p_wip_entity_id ;
1895:
1896: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,

Line 1962: ' wip_entities w' ||

1958: ' sj.primary_item_id,' ||
1959: ' tm.error_message' ||
1960: ' from wsm_split_merge_transactions tm,' ||
1961: ' wsm_sm_starting_jobs sj,' ||
1962: ' wip_entities w' ||
1963: ' where sj.transaction_id = tm.transaction_id' ||
1964: ' and sj.wip_entity_id = w.wip_entity_id' ||
1965: ' and w.wip_entity_id = ' || p_wip_entity_id ||
1966: ' order by 1' ;

Line 2018: ' wip_entities w' ||

2014: ' rj.starting_std_op_id,' ||
2015: ' tm.error_message' ||
2016: ' from wsm_split_merge_transactions tm,' ||
2017: ' wsm_sm_resulting_jobs rj,' ||
2018: ' wip_entities w' ||
2019: ' where rj.transaction_id = tm.transaction_id' ||
2020: ' and rj.wip_entity_id = w.wip_entity_id' ||
2021: ' and rj.transaction_id in (select wssj.transaction_id' ||
2022: ' from wsm_sm_starting_jobs wssj' ||

Line 2076: ' wip_entities w' ||

2072: ' rj.starting_std_op_id,' ||
2073: ' tm.error_message' ||
2074: ' from wsm_split_merge_transactions tm,' ||
2075: ' wsm_sm_resulting_jobs rj,' ||
2076: ' wip_entities w' ||
2077: ' where rj.transaction_id = tm.transaction_id' ||
2078: ' and rj.wip_entity_id = w.wip_entity_id' ||
2079: ' and w.wip_entity_id = ' || p_wip_entity_id ||
2080: ' order by transaction_id' ;

Line 2127: ' wip_entities w' ||

2123: ' sj.primary_item_id,' ||
2124: ' tm.error_message' ||
2125: ' from wsm_split_merge_transactions tm,' ||
2126: ' wsm_sm_starting_jobs sj,' ||
2127: ' wip_entities w' ||
2128: ' where sj.transaction_id = tm.transaction_id' ||
2129: ' and sj.wip_entity_id = w.wip_entity_id' ||
2130: ' and sj.transaction_id in (select wsrj.transaction_id' ||
2131: ' from wsm_sm_resulting_jobs wsrj' ||

Line 2215: 'from wip_repetitive_schedules a , wip_repetitive_items wri, wip_entities b, mtl_system_items m , mtl_parameters p '||

2211: ' a.bom_revision, '||
2212: ' a.routing_revision, '||
2213: ' nvl(a.alternate_bom_designator, ''PRIMARY'') alternate_bom_designator, '||
2214: ' nvl(a.alternate_routing_designator, ''PRIMARY'') alternate_routing_designator '||
2215: 'from wip_repetitive_schedules a , wip_repetitive_items wri, wip_entities b, mtl_system_items m , mtl_parameters p '||
2216: 'where b.wip_entity_id = a.wip_entity_id '||
2217: 'and wri.wip_entity_id = a.wip_entity_id '||
2218: 'and b.organization_id = a.organization_id '||
2219: 'and m.inventory_item_id = b.primary_item_id '||

Line 2237: 'WIP HEADER ( WIP REPETITIVE SCHEDULES, WIP REPETITIVE ITEMS, WIP ENTITIES )',null,'Y',row_limit);

2233: sqltxt := sqltxt ||' and a.repetitive_schedule_id = '|| p_rep_schedule_id;
2234: end if;
2235:
2236: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2237: 'WIP HEADER ( WIP REPETITIVE SCHEDULES, WIP REPETITIVE ITEMS, WIP ENTITIES )',null,'Y',row_limit);
2238:
2239: IF (dummy_num = row_limit) THEN
2240: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2241: END IF;

Line 2270: 'from wip_operations a, wip_entities b, bom_departments c, bom_standard_operations bso ' ||

2266: ' 2, ''No'') backflush_flag, ' ||
2267: ' a.minimum_transfer_quantity, ' ||
2268: ' a.date_last_moved, ' ||
2269: ' a.creation_date ' ||
2270: 'from wip_operations a, wip_entities b, bom_departments c, bom_standard_operations bso ' ||
2271: 'where a.wip_entity_id = b.wip_entity_id ' ||
2272: 'and a.organization_id = b.organization_id ' ||
2273: 'and a.department_id = c.department_id ' ||
2274: 'and a.organization_id = c.organization_id ' ||

Line 2318: 'from wip_requirement_operations a, wip_entities b, mtl_system_items_kfv m '||

2314: ' a.quantity_allocated, '||
2315: ' a.quantity_backordered, '||
2316: ' a.quantity_relieved, '||
2317: ' a.creation_date '||
2318: 'from wip_requirement_operations a, wip_entities b, mtl_system_items_kfv m '||
2319: 'where b.wip_entity_id = a.wip_entity_id '||
2320: 'and b.organization_id = a.organization_id '||
2321: 'and a.inventory_item_id = m.inventory_item_id '||
2322: 'and a.organization_id = m.organization_id ';

Line 3099: ' wip_entities we, '||

3095: 'WHERE trl.move_order_type <> 6 '||
3096: 'AND (trl.txn_source_id, trl.txn_source_line_id) in '||
3097: ' (select wdj.wip_entity_id, wro.operation_seq_num '||
3098: ' from wip_discrete_jobs wdj, '||
3099: ' wip_entities we, '||
3100: ' wip_lines wl, '||
3101: ' wip_requirement_operations wro '||
3102: ' where wdj.wip_entity_id = we.wip_entity_id '||
3103: ' and wdj.organization_id = we.organization_id '||

Line 3424: ' WIP_ENTITIES WE, '||

3420: ' to_char(RES.CREATION_DATE, ''DD-MON HH24:MI:SS'') CREATE_DATE, '||
3421: ' to_char(RES.LAST_UPDATE_DATE, ''DD-MON HH24:MI:SS'') UPD_DATE '||
3422: 'from '||
3423: ' MTL_RESERVATIONS RES, '||
3424: ' WIP_ENTITIES WE, '||
3425: ' WIP_DISCRETE_JOBS JOB '||
3426: 'where RES.SUPPLY_SOURCE_HEADER_ID = We.WIP_ENTITY_ID '||
3427: 'and We.WIP_ENTITY_ID = JOB.WIP_ENTITY_ID ';
3428:

Line 3858: ' from wip_entities ';

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:
3861: if p_wip_entity_id is not null then
3862: sqltxt :=sqltxt||' where wip_entity_id = '|| p_wip_entity_id ||')';

Line 4036: ' from wip_entities ';

4032: ' picking_order, '||
4033: ' source_subinventory '||
4034: 'from mtl_secondary_inventories '||
4035: 'where organization_id = (select organization_id '||
4036: ' from wip_entities ';
4037:
4038:
4039: if p_wip_entity_id is not null then
4040: sqltxt :=sqltxt||' where wip_entity_id = '|| p_wip_entity_id ||')';

Line 4090: ' from wip_flow_schedules a , wip_entities b, mtl_system_items_kfv m, mtl_parameters p ' ||

4086: ' a.bom_revision, ' ||
4087: ' a.routing_revision, ' ||
4088: ' nvl(a.alternate_bom_designator, ''PRIMARY'') alternate_bom_designator, ' ||
4089: ' nvl(a.alternate_routing_designator, ''PRIMARY'') alternate_routing_designator ' ||
4090: ' from wip_flow_schedules a , wip_entities b, mtl_system_items_kfv m, mtl_parameters p ' ||
4091: ' where b.wip_entity_id = a.wip_entity_id ' ||
4092: ' and b.organization_id = a.organization_id ' ||
4093: ' and m.inventory_item_id = a.primary_item_id ' ||
4094: ' and m.organization_id = a.organization_id ' ||

Line 4103: 'JOB HEADER ( WIP FLOW SCHEDULES , WIP ENTITIES )',null,'Y',row_limit);

4099: end if;
4100:
4101:
4102: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4103: 'JOB HEADER ( WIP FLOW SCHEDULES , WIP ENTITIES )',null,'Y',row_limit);
4104:
4105: IF (dummy_num = row_limit) THEN
4106: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4107: END IF;

Line 4260: ' from wip_entities we '||

4256: ' wt.move_transaction_id, '||
4257: ' wt.completion_transaction_id '||
4258: 'from wip_transactions wt '||
4259: 'where exists (select 1 '||
4260: ' from wip_entities we '||
4261: ' where we.wip_entity_id = wt.wip_entity_id '||
4262: ' and we.entity_type <> 2) '; /* Other than Repetitive */
4263:
4264: if p_wip_entity_id is not null then

Line 4630: ' wip_entities we, '||

4626: 'WHERE trl.move_order_type <> 6 '||
4627: 'AND (trl.txn_source_id, trl.txn_source_line_id) in '||
4628: ' (select wdj.wip_entity_id, wro.operation_seq_num '||
4629: ' from wip_flow_schedules wdj, '||
4630: ' wip_entities we, '||
4631: ' wip_lines wl, '||
4632: ' wip_requirement_operations wro '||
4633: ' where wdj.wip_entity_id = we.wip_entity_id '||
4634: ' and wdj.organization_id = we.organization_id '||

Line 4717: ' from wip_entities '||

4713: ' error_code '||
4714: 'from mtl_material_transactions '||
4715: 'where transaction_source_type_id = 5 '||
4716: 'and exists (select 1 '||
4717: ' from wip_entities '||
4718: ' where wip_entity_id = transaction_source_id '||
4719: ' and entity_type <> 2 ) '; /* Other than repetitive schedule */
4720:
4721: if p_wip_entity_id is not null then

Line 4931: ' WIP_ENTITIES WE, '||

4927: ' to_char(RES.CREATION_DATE, ''DD-MON HH24:MI:SS'') CREATE_DATE, '||
4928: ' to_char(RES.LAST_UPDATE_DATE, ''DD-MON HH24:MI:SS'') UPD_DATE '||
4929: 'from '||
4930: ' MTL_RESERVATIONS RES, '||
4931: ' WIP_ENTITIES WE, '||
4932: ' WIP_FLOW_SCHEDULES JOB '||
4933: 'where RES.SUPPLY_SOURCE_HEADER_ID = We.WIP_ENTITY_ID '||
4934: 'and We.WIP_ENTITY_ID = JOB.WIP_ENTITY_ID ';
4935:

Line 4971: ' from wip_entities ';

4967: ' picking_order, '||
4968: ' source_subinventory '||
4969: 'from mtl_secondary_inventories '||
4970: 'where organization_id = (select organization_id '||
4971: ' from wip_entities ';
4972:
4973:
4974: if p_wip_entity_id is not null then
4975: sqltxt :=sqltxt||' where wip_entity_id = '|| p_wip_entity_id ||')';