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 3644: /* Bug 3267578: Added not exists from MTL_TRANSACTIONS_INTERFACE */

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 5179: AND not exists ( select 1 from mtl_transactions_interface

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

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

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

Line 5249: AND not exists ( select 1 from mtl_transactions_interface

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

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

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

Line 5313: AND not exists ( select 1 from mtl_transactions_interface

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

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

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

Line 5419: AND not exists ( select 1 from mtl_transactions_interface

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

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

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

Line 5483: AND not exists ( select 1 from mtl_transactions_interface

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

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

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

Line 5543: AND not exists ( select 1 from mtl_transactions_interface

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

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

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

Line 5657: AND not exists ( select 1 from mtl_transactions_interface

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

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

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

Line 5778: AND not exists ( select 1 from mtl_transactions_interface

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