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.MRP_FLOW_SCHEDULE_UTIL dependencies on MTL_TRANSACTIONS_INTERFACE

Line 3641: /* Bug 3267578: Added not exists from MTL_TRANSACTIONS_INTERFACE */

3637: l_where_clause := l_where_clause || l_item_where_clause ||
3638: l_cat_where_clause;
3639:
3640: --fix bug#3170105
3641: /* Bug 3267578: Added not exists from MTL_TRANSACTIONS_INTERFACE */
3642: l_sql_stmt :=
3643: 'SELECT wfs.wip_entity_id, wfs.demand_source_line, msi.replenish_to_order_flag, msi.build_in_wip_flag ' ||
3644: ' FROM wip_flow_schedules wfs, mtl_system_items msi ' ||
3645: ' WHERE wfs.primary_item_id = msi.inventory_item_id '||

Line 3653: ' and not exists ( select 1 from mtl_transactions_interface ' ||

3649: ' AND wfs.status = 1 AND wfs.quantity_completed = 0 ' ||
3650: ' AND wfs.scheduled_completion_date between ' ||
3651: ' :start_date ' ||
3652: ' and :end_date '||
3653: ' and not exists ( select 1 from mtl_transactions_interface ' ||
3654: ' where transaction_source_id = wfs.wip_entity_id ' ||
3655: ' and organization_id = wfs.organization_id ' ||
3656: ' and transaction_source_type_id = 5 ' || -- perf bug 4911894
3657: ' and transaction_action_id in (1, 27, 30, 31, 32, 33, 34) ) ';

Line 4332: /* Bug 2998385: Added not exists from MTL_TRANSACTIONS_INTERFACE */

4328: l_cat_table_sql := ' ';
4329: l_cat_sql := ' ';
4330: END IF;
4331:
4332: /* Bug 2998385: Added not exists from MTL_TRANSACTIONS_INTERFACE */
4333: -- Define the select statement
4334: --fix bug#3170105
4335: l_sql_stmt :=
4336: 'SELECT fs.wip_entity_id ' ||

Line 4350: ' and not exists ( select 1 from mtl_transactions_interface ' ||

4346: ' and nvl(fs.status ,0) = 1 '||
4347: l_cat_sql ||
4348: ' and msi.inventory_item_id = fs.primary_item_id ' ||
4349: ' and msi.organization_id = fs.organization_id ' ||
4350: ' and not exists ( select 1 from mtl_transactions_interface ' ||
4351: ' where transaction_source_id = fs.wip_entity_id ' ||
4352: ' and organization_id = fs.organization_id ' ||
4353: ' and transaction_source_type_id = 5 ' || -- perf bug 4911894
4354: ' and transaction_action_id in (1, 27, 30, 31, 32, 33, 34) ) ';

Line 4487: /* Bug 2998385: Added not exists from MTL_TRANSACTIONS_INTERFACE */

4483: l_cat_table_sql := ' ';
4484: l_cat_sql := ' ';
4485: END IF;
4486:
4487: /* Bug 2998385: Added not exists from MTL_TRANSACTIONS_INTERFACE */
4488: --fix bug#3170105
4489: l_sql_stmt :=
4490: ' SELECT fs.line_id, line.line_code, fs.primary_item_id, ' ||
4491: ' msi.concatenated_segments,null' ||

Line 4511: ' and not exists ( select 1 from mtl_transactions_interface ' ||

4507: -- ' and nvl(fs.status ,0) = 1 '||
4508: l_cat_sql ||
4509: ' and msi.inventory_item_id = fs.primary_item_id ' ||
4510: ' and msi.organization_id = fs.organization_id '||
4511: ' and not exists ( select 1 from mtl_transactions_interface ' ||
4512: ' where transaction_source_id = fs.wip_entity_id ' ||
4513: ' and organization_id = fs.organization_id '||
4514: ' and transaction_source_type_id = 5 ' || -- perf bug 4911894
4515: ' and transaction_action_id in (1, 27, 30, 31, 32, 33, 34) ) ' ||

Line 4669: /* Bug 2998385: Added not exists from MTL_TRANSACTIONS_INTERFACE */

4665: l_cat_table_sql := ' ';
4666: l_cat_sql := ' ';
4667: END IF;
4668:
4669: /* Bug 2998385: Added not exists from MTL_TRANSACTIONS_INTERFACE */
4670: -- Define the select statement
4671: --fix bug#3170105
4672: l_sql_stmt :=
4673: ' SELECT fs.line_id, line.line_code, fs.primary_item_id, ' ||

Line 4714: ' and not exists ( select 1 from mtl_transactions_interface ' ||

4710: ' and nvl(fs.status,0) = 1 '||
4711: l_cat_sql ||
4712: ' and msi.inventory_item_id = fs.primary_item_id ' ||
4713: ' and msi.organization_id = fs.organization_id '||
4714: ' and not exists ( select 1 from mtl_transactions_interface ' ||
4715: ' where transaction_source_id = fs.wip_entity_id ' ||
4716: ' and organization_id = fs.organization_id ' ||
4717: ' and transaction_source_type_id = 5 ' || -- perf bug 4911894
4718: ' and transaction_action_id in (1, 27, 30, 31, 32, 33, 34) ) ' ||

Line 5027: /* Bug 2998385: Added not exists from MTL_TRANSACTIONS_INTERFACE */

5023: l_cat_table_sql := ' ';
5024: l_cat_sql := ' ';
5025: END IF;
5026:
5027: /* Bug 2998385: Added not exists from MTL_TRANSACTIONS_INTERFACE */
5028: -- Define the select statement
5029: --fix bug#3170105
5030: l_sql_stmt :=
5031: ' SELECT fs.wip_entity_id ' ||

Line 5047: ' and not exists ( select 1 from mtl_transactions_interface ' ||

5043: ' and line.organization_id = fs.organization_id '||
5044: l_cat_sql ||
5045: ' and msi.inventory_item_id = fs.primary_item_id ' ||
5046: ' and msi.organization_id = fs.organization_id ' ||
5047: ' and not exists ( select 1 from mtl_transactions_interface ' ||
5048: ' where transaction_source_id = fs.wip_entity_id ' ||
5049: ' and organization_id = fs.organization_id ' ||
5050: ' and transaction_source_type_id = 5 ' || -- perf bug 4911894
5051: ' and transaction_action_id in (1, 27, 30, 31, 32, 33, 34) ) ';

Line 5115: /* Bug 2998385: Added not exists from MTL_TRANSACTIONS_INTERFACE */

5111:
5112: IF (p_from_category IS NOT NULL OR p_to_category IS NOT NULL)
5113: AND p_category_set_id IS NOT NULL THEN
5114:
5115: /* Bug 2998385: Added not exists from MTL_TRANSACTIONS_INTERFACE */
5116: INSERT INTO mrp_form_query
5117: (query_id,
5118: last_update_date,
5119: last_updated_by,

Line 5176: AND not exists ( select 1 from mtl_transactions_interface

5172: AND fs1.scheduled_completion_date --fix bug#3170105
5173: BETWEEN p_from_start_date AND
5174: p_from_end_date+1-1/(24*60*60)
5175: AND fs1.organization_id = p_organization_id
5176: AND not exists ( select 1 from mtl_transactions_interface
5177: where transaction_source_id = fs1.wip_entity_id
5178: and organization_id = fs1.organization_id
5179: and transaction_source_type_id = 5 -- perf bug 4911894
5180: and transaction_action_id in (1, 27, 30, 31, 32, 33, 34) )

Line 5190: /* Bug 2998385: Added not exists from MTL_TRANSACTIONS_INTERFACE */

5186: fs1.organization_id;
5187:
5188: ELSIF p_category_set_id IS NOT NULL THEN
5189:
5190: /* Bug 2998385: Added not exists from MTL_TRANSACTIONS_INTERFACE */
5191: INSERT INTO mrp_form_query
5192: (query_id,
5193: last_update_date,
5194: last_updated_by,

Line 5246: AND not exists ( select 1 from mtl_transactions_interface

5242: AND fs1.scheduled_completion_date --fix bug#3170105
5243: BETWEEN p_from_start_date AND
5244: p_from_end_date+1-1/(24*60*60)
5245: AND fs1.organization_id = p_organization_id
5246: AND not exists ( select 1 from mtl_transactions_interface
5247: where transaction_source_id = fs1.wip_entity_id
5248: and organization_id = fs1.organization_id
5249: and transaction_source_type_id = 5 -- perf bug 4911894
5250: and transaction_action_id in (1, 27, 30, 31, 32, 33, 34) )

Line 5258: /* Bug 2998385: Added not exists from MTL_TRANSACTIONS_INTERFACE */

5254: trunc(flm_timezone.server_to_client(fs1.scheduled_completion_date)),--bug 3827600
5255: --floor(fs1.scheduled_completion_date-p_from_start_date), --fix bug#3170105
5256: fs1.organization_id;
5257: ELSE
5258: /* Bug 2998385: Added not exists from MTL_TRANSACTIONS_INTERFACE */
5259: INSERT INTO mrp_form_query
5260: (query_id,
5261: last_update_date,
5262: last_updated_by,

Line 5310: AND not exists ( select 1 from mtl_transactions_interface

5306: AND fs1.scheduled_completion_date --fix bug#3170105
5307: BETWEEN p_from_start_date AND
5308: p_from_end_date+1-1/(24*60*60)
5309: AND fs1.organization_id = p_organization_id
5310: AND not exists ( select 1 from mtl_transactions_interface
5311: where transaction_source_id = fs1.wip_entity_id
5312: and organization_id = fs1.organization_id
5313: and transaction_source_type_id = 5 -- perf bug 4911894
5314: and transaction_action_id in (1, 27, 30, 31, 32, 33, 34) )

Line 5355: /* Bug 2998385: Added not exists from MTL_TRANSACTIONS_INTERFACE */

5351:
5352: IF (p_from_category IS NOT NULL OR p_to_category IS NOT NULL)
5353: AND p_category_set_id IS NOT NULL THEN
5354:
5355: /* Bug 2998385: Added not exists from MTL_TRANSACTIONS_INTERFACE */
5356: INSERT INTO mrp_form_query
5357: (query_id,
5358: last_update_date,
5359: last_updated_by,

Line 5416: AND not exists ( select 1 from mtl_transactions_interface

5412: AND fs1.scheduled_completion_date --fix bug#3170105
5413: BETWEEN p_from_start_date AND
5414: p_from_end_date+1-1/(24*60*60)
5415: AND fs1.organization_id = p_organization_id
5416: AND not exists ( select 1 from mtl_transactions_interface
5417: where transaction_source_id = fs1.wip_entity_id
5418: and organization_id = fs1.organization_id
5419: and transaction_source_type_id = 5 -- perf bug 4911894
5420: and transaction_action_id in (1, 27, 30, 31, 32, 33, 34) );

Line 5424: /* Bug 2998385: Added not exists from MTL_TRANSACTIONS_INTERFACE */

5420: and transaction_action_id in (1, 27, 30, 31, 32, 33, 34) );
5421:
5422: ELSIF p_category_set_id IS NOT NULL THEN
5423:
5424: /* Bug 2998385: Added not exists from MTL_TRANSACTIONS_INTERFACE */
5425: INSERT INTO mrp_form_query
5426: (query_id,
5427: last_update_date,
5428: last_updated_by,

Line 5480: AND not exists ( select 1 from mtl_transactions_interface

5476: AND fs1.scheduled_completion_date --fix bug#3170105
5477: BETWEEN p_from_start_date AND
5478: p_from_end_date+1-1/(24*60*60)
5479: AND fs1.organization_id = p_organization_id
5480: AND not exists ( select 1 from mtl_transactions_interface
5481: where transaction_source_id = fs1.wip_entity_id
5482: and organization_id = fs1.organization_id
5483: and transaction_source_type_id = 5
5484: and transaction_action_id in (1, 27, 30, 31, 32, 33, 34) );

Line 5488: /* Bug 2998385: Added not exists from MTL_TRANSACTIONS_INTERFACE */

5484: and transaction_action_id in (1, 27, 30, 31, 32, 33, 34) );
5485:
5486: ELSE
5487:
5488: /* Bug 2998385: Added not exists from MTL_TRANSACTIONS_INTERFACE */
5489: INSERT INTO mrp_form_query
5490: (query_id,
5491: last_update_date,
5492: last_updated_by,

Line 5540: AND not exists ( select 1 from mtl_transactions_interface

5536: AND fs1.scheduled_completion_date --fix bug#3170105
5537: BETWEEN p_from_start_date AND
5538: p_from_end_date+1-1/(24*60*60)
5539: AND fs1.organization_id = p_organization_id
5540: AND not exists ( select 1 from mtl_transactions_interface
5541: where transaction_source_id = fs1.wip_entity_id
5542: and organization_id = fs1.organization_id
5543: and transaction_source_type_id = 5
5544: and transaction_action_id in (1, 27, 30, 31, 32, 33,34) );

Line 5610: /* Bug 2998385: Added not exists from MTL_TRANSACTIONS_INTERFACE */

5606: FETCH C1 INTO l_rowid;
5607:
5608: IF C1%NOTFOUND THEN
5609:
5610: /* Bug 2998385: Added not exists from MTL_TRANSACTIONS_INTERFACE */
5611: INSERT INTO mrp_form_query
5612: (query_id,
5613: last_update_date,
5614: last_updated_by,

Line 5654: AND not exists ( select 1 from mtl_transactions_interface

5650: AND nvl(fs.schedule_group_id,-1) = nvl(p_schedule_group_id,-1)
5651: AND scheduled_completion_date
5652: BETWEEN flm_timezone.client00_in_server(p_completion_date)
5653: AND flm_timezone.client00_in_server(p_completion_date)+1-1/(24*60*60) --fix bug#3170105
5654: AND not exists ( select 1 from mtl_transactions_interface
5655: where transaction_source_id = fs.wip_entity_id
5656: and organization_id = fs.organization_id
5657: and transaction_source_type_id = 5
5658: and transaction_action_id in (1, 27, 30, 31, 32, 33, 34) );

Line 5732: /* Bug 2998385: Added not exists from MTL_TRANSACTIONS_INTERFACE */

5728: FETCH C1 INTO l_rowid;
5729:
5730: IF C1%NOTFOUND THEN
5731:
5732: /* Bug 2998385: Added not exists from MTL_TRANSACTIONS_INTERFACE */
5733: INSERT INTO mrp_form_query
5734: (query_id,
5735: last_update_date,
5736: last_updated_by,

Line 5775: AND not exists ( select 1 from mtl_transactions_interface

5771: --4 AND nvl(fs.schedule_group_id,-1) = nvl(p_schedule_group_id,-1)
5772: AND scheduled_completion_date
5773: BETWEEN flm_timezone.client00_in_server(p_completion_date)
5774: AND flm_timezone.client00_in_server(p_completion_date)+1-1/(24*60*60) --fix bug#317010
5775: AND not exists ( select 1 from mtl_transactions_interface
5776: where transaction_source_id = fs.wip_entity_id
5777: and organization_id = fs.organization_id
5778: and transaction_source_type_id = 5
5779: and transaction_action_id in (1, 27, 30, 31, 32, 33, 34) );