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.INV_SHORTCHECKEXEC_PVT dependencies on MTL_SHORT_CHK_TEMP

Line 64: FROM mtl_short_chk_temp

60: CURSOR L_Quantity_crs (p_organization_id IN NUMBER,
61: p_seq_num IN NUMBER) IS
62: SELECT sum(quantity_open) short_quantity,
63: inventory_item_id
64: FROM mtl_short_chk_temp
65: WHERE organization_id = p_organization_id
66: AND seq_num = p_seq_num -- Bug 5081665: filter on seq_num
67: group by inventory_item_id;
68:

Line 115: SELECT mtl_short_chk_temp_s.NEXTVAL

111: 0);
112: END IF;
113: -- If statement type is detail then pull sequence number and bind it
114: IF p_sum_detail_flag = 1 THEN
115: SELECT mtl_short_chk_temp_s.NEXTVAL
116: INTO x_seq_num
117: FROM dual;
118: --
119: dbms_sql.bind_variable(L_ExecStatement_crs,':seq_num',

Line 241: select count(*) into L_count from mtl_short_chk_temp;

237:
238: -- Bug #4474266 Added the IF condition for p_sum_detail_flag = 0
239:
240: IF p_sum_detail_flag = 0 THEN
241: select count(*) into L_count from mtl_short_chk_temp;
242:
243: IF L_count > 0 then
244: Begin
245: FOR L_Quantity_rec in L_Quantity_crs (p_organization_id, x_seq_num)

Line 253: delete from mtl_short_chk_temp

249: p_inventory_item_id => L_Quantity_rec.inventory_item_id,
250: p_short_quantity => L_Quantity_rec.short_quantity);
251:
252: IF x_check_result = FND_API.G_FALSE THEN
253: delete from mtl_short_chk_temp
254: where inventory_item_id = L_Quantity_rec.inventory_item_id
255: and seq_num = x_seq_num -- Bug 5081665: filter on seq_num
256: and organization_id = p_organization_id;
257: END IF;

Line 297: -- Set x_check_result according to mtl_short_chk_temp table contents

293: x_seq_num => x_seq_num,
294: x_wip_short_quantity => L_WIP_short_quantity,
295: x_oe_short_quantity => L_OE_short_quantity
296: );
297: -- Set x_check_result according to mtl_short_chk_temp table contents
298: BEGIN
299: SELECT FND_API.G_TRUE
300: INTO x_check_result
301: FROM mtl_short_chk_temp

Line 301: FROM mtl_short_chk_temp

297: -- Set x_check_result according to mtl_short_chk_temp table contents
298: BEGIN
299: SELECT FND_API.G_TRUE
300: INTO x_check_result
301: FROM mtl_short_chk_temp
302: WHERE seq_num = x_seq_num
303: AND rownum < 2;
304: EXCEPTION
305: WHEN NO_DATA_FOUND THEN

Line 594: mtl_short_chk_temp MSCT

590: SELECT DISTINCT FU.user_name user_name
591: FROM mtl_planners MP,
592: mtl_system_items MSI,
593: fnd_user FU,
594: mtl_short_chk_temp MSCT
595: WHERE L_ShortParam_rec.wip_notif_comp_planner_flag = 1
596: AND MSCT.object_type IN (1,2)
597: AND MSCT.seq_num = p_seq_num
598: AND MSCT.inventory_item_id = MSI.inventory_item_id

Line 610: mtl_short_chk_temp MSCT

606: FROM mtl_planners MP,
607: mtl_system_items MSI,
608: wip_entities WE,
609: fnd_user FU,
610: mtl_short_chk_temp MSCT
611: WHERE L_ShortParam_rec.wip_notif_ass_planner_flag = 1
612: AND MSCT.seq_num = p_seq_num
613: AND MSCT.object_type = 1
614: AND MSCT.object_id = WE.wip_entity_id

Line 628: mtl_short_chk_temp MSCT

624: mtl_system_items MSI,
625: wip_repetitive_schedules WRS,
626: wip_repetitive_items WRI,
627: fnd_user FU,
628: mtl_short_chk_temp MSCT
629: WHERE L_ShortParam_rec.wip_notif_ass_planner_flag = 1
630: AND MSCT.seq_num = p_seq_num
631: AND MSCT.object_type = 2
632: AND MSCT.object_id = WRS.repetitive_schedule_id

Line 646: mtl_short_chk_temp MSCT

642: UNION
643: SELECT DISTINCT FU.user_name
644: FROM mtl_system_items MSI,
645: fnd_user FU,
646: mtl_short_chk_temp MSCT
647: WHERE L_ShortParam_rec.wip_notif_comp_buyer_flag = 1
648: AND MSCT.seq_num = p_seq_num
649: AND MSCT.object_type IN (1,2)
650: AND MSCT.inventory_item_id = MSI.inventory_item_id

Line 658: mtl_short_chk_temp MSCT

654: UNION
655: SELECT DISTINCT FU.user_name
656: FROM fnd_user FU,
657: wip_discrete_jobs WDJ,
658: mtl_short_chk_temp MSCT
659: WHERE L_ShortParam_rec.wip_notif_job_creator_flag = 1
660: AND MSCT.seq_num = p_seq_num
661: AND MSCT.object_type = 1
662: AND MSCT.object_id = WDJ.wip_entity_id

Line 670: mtl_short_chk_temp MSCT

666: UNION
667: SELECT DISTINCT FU.user_name
668: FROM fnd_user FU,
669: wip_repetitive_schedules WRS,
670: mtl_short_chk_temp MSCT
671: WHERE L_ShortParam_rec.wip_notif_job_creator_flag = 1
672: AND MSCT.seq_num = p_seq_num
673: AND MSCT.object_type = 2
674: AND MSCT.object_id = WRS.repetitive_schedule_id

Line 683: mtl_short_chk_temp MSCT

679: SELECT DISTINCT FU.user_name user_name
680: FROM mtl_planners MP,
681: mtl_system_items MSI,
682: fnd_user FU,
683: mtl_short_chk_temp MSCT
684: WHERE L_ShortParam_rec.oe_notif_item_planner_flag = 1
685: AND MSCT.object_type = 4
686: AND MSCT.seq_num = p_seq_num
687: AND MSCT.inventory_item_id = MSI.inventory_item_id

Line 697: mtl_short_chk_temp MSCT

693: UNION
694: SELECT DISTINCT FU.user_name
695: FROM fnd_user FU,
696: oe_order_headers SH,
697: mtl_short_chk_temp MSCT
698: WHERE L_ShortParam_rec.oe_notif_so_creator_flag = 1
699: AND MSCT.seq_num = p_seq_num
700: AND MSCT.object_type = 4
701: AND MSCT.object_id = SH.header_id

Line 936: DELETE FROM mtl_short_chk_temp

932: -- Initialize API return status to success
933: x_return_status := FND_API.G_RET_STS_SUCCESS;
934: --
935: -- Purge all rows with the given sequence number
936: DELETE FROM mtl_short_chk_temp
937: WHERE seq_num = p_seq_num;
938: --
939: -- Standard check of p_commit
940: IF FND_API.to_Boolean(p_commit) THEN