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 STANDARD

Line 38: ' decode(a.job_type, 1, ''Standard'', ' ||

34: ' 13, ''Pending- Mass Loaded'', ' ||
35: ' 14, ''Pending Close'', ' ||
36: ' 15, ''Failed Close'', ' ||
37: ' a.status_type) status_type, ' ||
38: ' decode(a.job_type, 1, ''Standard'', ' ||
39: ' 3, ''Non-Standard'', ' ||
40: ' a.job_type) job_type, ' ||
41: ' a.lot_number, ' ||
42: ' a.completion_subinventory, ' ||

Line 39: ' 3, ''Non-Standard'', ' ||

35: ' 14, ''Pending Close'', ' ||
36: ' 15, ''Failed Close'', ' ||
37: ' a.status_type) status_type, ' ||
38: ' decode(a.job_type, 1, ''Standard'', ' ||
39: ' 3, ''Non-Standard'', ' ||
40: ' a.job_type) job_type, ' ||
41: ' a.lot_number, ' ||
42: ' a.completion_subinventory, ' ||
43: ' a.completion_locator_id, ' ||

Line 95: ' a.standard_operation_id, ' ||

91:
92: sqltxt :=
93: 'select a.operation_seq_num, ' ||
94: ' a.operation_sequence_id, ' ||
95: ' a.standard_operation_id, ' ||
96: ' bso.operation_code , ' ||
97: ' a.department_id, ' ||
98: ' c.department_code, ' ||
99: ' a.description, ' ||

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 124: 'and a.standard_operation_id = bso.standard_operation_id(+) ' ||

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 ' ||
124: 'and a.standard_operation_id = bso.standard_operation_id(+) ' ||
125: 'and a.organization_id = bso.organization_id(+) ';
126:
127: if p_wip_entity_id is not null then
128: sqltxt :=sqltxt||' and b.wip_entity_id = '|| p_wip_entity_id;

Line 257: ' decode(class_type,1,''Standard Discrete'', '||

253: END IF;
254:
255: sqltxt :=
256: 'select acct_period_id, '||
257: ' decode(class_type,1,''Standard Discrete'', '||
258: ' 2,''Repetitive Assembly'', '||
259: ' 3,''Asset non-standard'', '||
260: ' 4,''Expense non-standard'', '||
261: ' 5,''Standard Lot Based'', '||

Line 259: ' 3,''Asset non-standard'', '||

255: sqltxt :=
256: 'select acct_period_id, '||
257: ' decode(class_type,1,''Standard Discrete'', '||
258: ' 2,''Repetitive Assembly'', '||
259: ' 3,''Asset non-standard'', '||
260: ' 4,''Expense non-standard'', '||
261: ' 5,''Standard Lot Based'', '||
262: ' 6,''EAM'', '||
263: ' 7,''Expense non-standard Lot Based'', '||

Line 260: ' 4,''Expense non-standard'', '||

256: 'select acct_period_id, '||
257: ' decode(class_type,1,''Standard Discrete'', '||
258: ' 2,''Repetitive Assembly'', '||
259: ' 3,''Asset non-standard'', '||
260: ' 4,''Expense non-standard'', '||
261: ' 5,''Standard Lot Based'', '||
262: ' 6,''EAM'', '||
263: ' 7,''Expense non-standard Lot Based'', '||
264: ' class_type) class_type, '||

Line 261: ' 5,''Standard Lot Based'', '||

257: ' decode(class_type,1,''Standard Discrete'', '||
258: ' 2,''Repetitive Assembly'', '||
259: ' 3,''Asset non-standard'', '||
260: ' 4,''Expense non-standard'', '||
261: ' 5,''Standard Lot Based'', '||
262: ' 6,''EAM'', '||
263: ' 7,''Expense non-standard Lot Based'', '||
264: ' class_type) class_type, '||
265: ' tl_resource_in, '||

Line 263: ' 7,''Expense non-standard Lot Based'', '||

259: ' 3,''Asset non-standard'', '||
260: ' 4,''Expense non-standard'', '||
261: ' 5,''Standard Lot Based'', '||
262: ' 6,''EAM'', '||
263: ' 7,''Expense non-standard Lot Based'', '||
264: ' class_type) class_type, '||
265: ' tl_resource_in, '||
266: ' tl_overhead_in, '||
267: ' tl_outside_processing_in, '||

Line 552: ' wt.standard_resource_rate, '||

548: ' wt.acct_period_id, '||
549: ' wt.resource_id, '||
550: ' wt.transaction_quantity, '||
551: ' wt.actual_resource_rate, '||
552: ' wt.standard_resource_rate, '||
553: ' wt.transaction_uom, '||
554: ' wt.move_transaction_id, '||
555: ' wt.completion_transaction_id '||
556: 'from wip_transactions wt '||

Line 1766: ' a.standard_operation_id, '||

1762: ' bor.routing_type) routing_type, '||
1763: ' a.operation_sequence_id, '||
1764: ' a.operation_seq_num, '||
1765: ' a.routing_sequence_id, '||
1766: ' a.standard_operation_id, '||
1767: ' b.operation_code, '||
1768: ' a.department_id, '||
1769: ' a.count_point_type, '||
1770: ' a.effectivity_date, '||

Line 1781: ' bom_standard_operations b , mtl_system_items_kfv msi '||

1777: ' decode(a.operation_yield_enabled, 1, ''Yes'', '||
1778: ' 2, ''No'', '||
1779: ' a.operation_yield_enabled) operation_yield_enabled '||
1780: 'from bom_operation_sequences a, bom_operational_routings bor, wip_discrete_jobs wj, '||
1781: ' bom_standard_operations b , mtl_system_items_kfv msi '||
1782: 'where a.routing_sequence_id = bor.common_routing_sequence_id '||
1783: 'and wj.organization_id = bor.organization_id '||
1784: 'and wj.common_routing_sequence_id = bor.routing_sequence_id '||
1785: 'and a.standard_operation_id = b.standard_operation_id(+) ' ||

Line 1785: 'and a.standard_operation_id = b.standard_operation_id(+) ' ||

1781: ' bom_standard_operations b , mtl_system_items_kfv msi '||
1782: 'where a.routing_sequence_id = bor.common_routing_sequence_id '||
1783: 'and wj.organization_id = bor.organization_id '||
1784: 'and wj.common_routing_sequence_id = bor.routing_sequence_id '||
1785: 'and a.standard_operation_id = b.standard_operation_id(+) ' ||
1786: 'and bor.assembly_item_id = msi.inventory_item_id '||
1787: 'and bor.organization_id = msi.organization_id ';
1788:
1789:

Line 2247: ' a.standard_operation_id, ' ||

2243:
2244: sqltxt :=
2245: 'select a.operation_seq_num, ' ||
2246: ' a.operation_sequence_id, ' ||
2247: ' a.standard_operation_id, ' ||
2248: ' bso.operation_code , ' ||
2249: ' a.department_id, ' ||
2250: ' c.department_code, ' ||
2251: ' a.description, ' ||

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 2275: 'and a.standard_operation_id = bso.standard_operation_id(+) ' ||

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 ' ||
2275: 'and a.standard_operation_id = bso.standard_operation_id(+) ' ||
2276: 'and a.organization_id = bso.organization_id(+) ';
2277:
2278: if p_wip_entity_id is not null then
2279: sqltxt :=sqltxt||' and a.wip_entity_id = '|| p_wip_entity_id;

Line 2420: ' decode(class_type,1,''Standard Discrete'', '||

2416: END IF;
2417:
2418: sqltxt :=
2419: 'select acct_period_id, '||
2420: ' decode(class_type,1,''Standard Discrete'', '||
2421: ' 2,''Repetitive Assembly'', '||
2422: ' 3,''Asset non-standard'', '||
2423: ' 4,''Expense non-standard'', '||
2424: ' 5,''Standard Lot Based'', '||

Line 2422: ' 3,''Asset non-standard'', '||

2418: sqltxt :=
2419: 'select acct_period_id, '||
2420: ' decode(class_type,1,''Standard Discrete'', '||
2421: ' 2,''Repetitive Assembly'', '||
2422: ' 3,''Asset non-standard'', '||
2423: ' 4,''Expense non-standard'', '||
2424: ' 5,''Standard Lot Based'', '||
2425: ' 6,''EAM'', '||
2426: ' 7,''Expense non-standard Lot Based'', '||

Line 2423: ' 4,''Expense non-standard'', '||

2419: 'select acct_period_id, '||
2420: ' decode(class_type,1,''Standard Discrete'', '||
2421: ' 2,''Repetitive Assembly'', '||
2422: ' 3,''Asset non-standard'', '||
2423: ' 4,''Expense non-standard'', '||
2424: ' 5,''Standard Lot Based'', '||
2425: ' 6,''EAM'', '||
2426: ' 7,''Expense non-standard Lot Based'', '||
2427: ' class_type) class_type, '||

Line 2424: ' 5,''Standard Lot Based'', '||

2420: ' decode(class_type,1,''Standard Discrete'', '||
2421: ' 2,''Repetitive Assembly'', '||
2422: ' 3,''Asset non-standard'', '||
2423: ' 4,''Expense non-standard'', '||
2424: ' 5,''Standard Lot Based'', '||
2425: ' 6,''EAM'', '||
2426: ' 7,''Expense non-standard Lot Based'', '||
2427: ' class_type) class_type, '||
2428: ' tl_resource_in, '||

Line 2426: ' 7,''Expense non-standard Lot Based'', '||

2422: ' 3,''Asset non-standard'', '||
2423: ' 4,''Expense non-standard'', '||
2424: ' 5,''Standard Lot Based'', '||
2425: ' 6,''EAM'', '||
2426: ' 7,''Expense non-standard Lot Based'', '||
2427: ' class_type) class_type, '||
2428: ' tl_resource_in, '||
2429: ' tl_overhead_in, '||
2430: ' tl_outside_processing_in, '||

Line 2722: ' wt.standard_resource_rate, '||

2718: ' wt.resource_id, '||
2719: ' wt.transaction_quantity, '||
2720: ' wta.transaction_quantity Allocation_Txn_Qty, ' ||
2721: ' wt.actual_resource_rate, '||
2722: ' wt.standard_resource_rate, '||
2723: ' wt.transaction_uom, '||
2724: ' wt.move_transaction_id, '||
2725: ' wt.completion_transaction_id '||
2726: 'from wip_transactions wt, '||

Line 3947: ' a.standard_operation_id, '||

3943: ' bor.routing_type) routing_type, '||
3944: ' a.operation_sequence_id, '||
3945: ' a.operation_seq_num, '||
3946: ' a.routing_sequence_id, '||
3947: ' a.standard_operation_id, '||
3948: ' b.operation_code, '||
3949: ' a.department_id, '||
3950: ' a.count_point_type, '||
3951: ' a.effectivity_date, '||

Line 3962: ' bom_standard_operations b , mtl_system_items_kfv msi '||

3958: ' decode(a.operation_yield_enabled, 1, ''Yes'', '||
3959: ' 2, ''No'', '||
3960: ' a.operation_yield_enabled) operation_yield_enabled '||
3961: 'from bom_operation_sequences a, bom_operational_routings bor, wip_discrete_jobs wj, '||
3962: ' bom_standard_operations b , mtl_system_items_kfv msi '||
3963: 'where a.routing_sequence_id = bor.common_routing_sequence_id '||
3964: 'and wj.organization_id = bor.organization_id '||
3965: 'and wj.common_routing_sequence_id = bor.routing_sequence_id '||
3966: 'and a.standard_operation_id = b.standard_operation_id(+) ' ||

Line 3966: 'and a.standard_operation_id = b.standard_operation_id(+) ' ||

3962: ' bom_standard_operations b , mtl_system_items_kfv msi '||
3963: 'where a.routing_sequence_id = bor.common_routing_sequence_id '||
3964: 'and wj.organization_id = bor.organization_id '||
3965: 'and wj.common_routing_sequence_id = bor.routing_sequence_id '||
3966: 'and a.standard_operation_id = b.standard_operation_id(+) ' ||
3967: 'and bor.assembly_item_id = msi.inventory_item_id '||
3968: 'and bor.organization_id = msi.organization_id ';
3969:
3970:

Line 4111: ' decode(class_type,1,''Standard Discrete'', '||

4107: END IF;
4108:
4109: sqltxt :=
4110: 'select acct_period_id, '||
4111: ' decode(class_type,1,''Standard Discrete'', '||
4112: ' 2,''Repetitive Assembly'', '||
4113: ' 3,''Asset non-standard'', '||
4114: ' 4,''Expense non-standard'', '||
4115: ' 5,''Standard Lot Based'', '||

Line 4113: ' 3,''Asset non-standard'', '||

4109: sqltxt :=
4110: 'select acct_period_id, '||
4111: ' decode(class_type,1,''Standard Discrete'', '||
4112: ' 2,''Repetitive Assembly'', '||
4113: ' 3,''Asset non-standard'', '||
4114: ' 4,''Expense non-standard'', '||
4115: ' 5,''Standard Lot Based'', '||
4116: ' 6,''EAM'', '||
4117: ' 7,''Expense non-standard Lot Based'', '||

Line 4114: ' 4,''Expense non-standard'', '||

4110: 'select acct_period_id, '||
4111: ' decode(class_type,1,''Standard Discrete'', '||
4112: ' 2,''Repetitive Assembly'', '||
4113: ' 3,''Asset non-standard'', '||
4114: ' 4,''Expense non-standard'', '||
4115: ' 5,''Standard Lot Based'', '||
4116: ' 6,''EAM'', '||
4117: ' 7,''Expense non-standard Lot Based'', '||
4118: ' class_type) class_type, '||

Line 4115: ' 5,''Standard Lot Based'', '||

4111: ' decode(class_type,1,''Standard Discrete'', '||
4112: ' 2,''Repetitive Assembly'', '||
4113: ' 3,''Asset non-standard'', '||
4114: ' 4,''Expense non-standard'', '||
4115: ' 5,''Standard Lot Based'', '||
4116: ' 6,''EAM'', '||
4117: ' 7,''Expense non-standard Lot Based'', '||
4118: ' class_type) class_type, '||
4119: ' tl_resource_in, '||

Line 4117: ' 7,''Expense non-standard Lot Based'', '||

4113: ' 3,''Asset non-standard'', '||
4114: ' 4,''Expense non-standard'', '||
4115: ' 5,''Standard Lot Based'', '||
4116: ' 6,''EAM'', '||
4117: ' 7,''Expense non-standard Lot Based'', '||
4118: ' class_type) class_type, '||
4119: ' tl_resource_in, '||
4120: ' tl_overhead_in, '||
4121: ' tl_outside_processing_in, '||

Line 4254: ' wt.standard_resource_rate, '||

4250: ' wt.acct_period_id, '||
4251: ' wt.resource_id, '||
4252: ' wt.transaction_quantity, '||
4253: ' wt.actual_resource_rate, '||
4254: ' wt.standard_resource_rate, '||
4255: ' wt.transaction_uom, '||
4256: ' wt.move_transaction_id, '||
4257: ' wt.completion_transaction_id '||
4258: 'from wip_transactions wt '||