DBA Data[Home] [Help]

APPS.MSC_RP_RELEASE_PUB dependencies on MSC_SUPPLIES

Line 86: FROM msc_supplies ms,

82: SELECT sum(decode(ms.load_type,20,0,1)),
83: sum(decode(ms.load_type,20,1,0)),
84: sum(decode(mai.lrtype, 'I', 0,
85: decode(nvl(mai.st_status,0),3,1,0)))
86: FROM msc_supplies ms,
87: msc_apps_instances mai
88: where ms.plan_id = pid
89: and ms.release_errors is null
90: and ms.load_type is not null

Line 579: AND p_SOURCE_TABLE = 'MSC_SUPPLIES') THEN

575: l_ship_method varchar2(30) := p_ship_method;
576:
577: BEGIN
578: IF (p_order_type in (1,2,5)
579: AND p_SOURCE_TABLE = 'MSC_SUPPLIES') THEN
580:
581: --- get the unique number identifying the current session
582: SELECT MRP.mrp_atp_schedule_temp_s.nextval
583: INTO l_session_id

Line 805: if (p_source_table='MSC_SUPPLIES' AND

801:
802:
803:
804: /* if it is supply and order type not in (1,2,3,5,13) */
805: if (p_source_table='MSC_SUPPLIES' AND
806: p_order_type NOT IN (1, 2, 3, 5, 13) )then
807: p_rel_error :=FND_MESSAGE.GET_STRING('MSC', 'MSC_WB_RELEASE_3');
808: return p_rel_error;
809: END IF;

Line 848: if (p_order_type=5 and p_source_table='MSC_SUPPLIES' and p_release_time_fence_code = 6) then

844:
845:
846:
847: /* Kanban item can not be released */
848: if (p_order_type=5 and p_source_table='MSC_SUPPLIES' and p_release_time_fence_code = 6) then
849: p_rel_error := FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_KANBAN');
850: return p_rel_error;
851: end if;
852: