DBA Data[Home] [Help]

APPS.MSC_OWB_TREE dependencies on MRP_ATP_DETAILS_TEMP

Line 189: from mrp_atp_details_temp

185:
186: BEGIN
187:
188: select CHAR1 into v_demand_class
189: from mrp_atp_details_temp
190: where record_type = 3
191: and pegging_id = p_pegging_id
192: and session_id = p_session_id;
193:

Line 549: FROM mrp_atp_details_temp

545: p_nodes.depth,
546: p_nodes.label,
547: p_nodes.icon,
548: p_nodes.data
549: FROM mrp_atp_details_temp
550: where nonatp_flag is NULL
551: start WITH
552: session_id = p_session_id
553: AND record_type = 3

Line 670: FROM mrp_atp_details_temp

666: p_nodes.depth,
667: p_nodes.label,
668: p_nodes.icon,
669: p_nodes.data
670: FROM mrp_atp_details_temp
671: where supply_demand_type = Decode(parent_pegging_id, NULL, 1,2)
672: /*and decode(p_current_pegging_id, NULL, -1 , atp_level) = decode(p_current_pegging_id , NULL, -1, dummy)*/
673: start WITH
674: session_id = p_session_id