DBA Data[Home] [Help]

APPS.GMP_APS_OUTPUT_PKG dependencies on MTL_SYSTEM_ITEMS

Line 174: mtl_system_items mtl

170: w.due_date , /* B3710615 12.0 */
171: w.priority /* B4039225 */
172: FROM
173: wip_job_schedule_interface w,
174: mtl_system_items mtl
175: WHERE
176: w.group_id = p_group_id
177: AND w.load_type = 1
178: AND w.process_status = 1

Line 641: v_item_id mtl_system_items.inventory_item_id%TYPE;

637: v_return_status VARCHAR2(50) ;
638: v_msg_count NUMBER ;
639: v_msg_data VARCHAR2(2000);
640:
641: v_item_id mtl_system_items.inventory_item_id%TYPE;
642: v_orgn_id mtl_system_items.organization_id%TYPE;
643:
644: /* cursor to get the company(operating units) and the cost method */
645: /* Per the inventory convergence inputs from costing team

Line 642: v_orgn_id mtl_system_items.organization_id%TYPE;

638: v_msg_count NUMBER ;
639: v_msg_data VARCHAR2(2000);
640:
641: v_item_id mtl_system_items.inventory_item_id%TYPE;
642: v_orgn_id mtl_system_items.organization_id%TYPE;
643:
644: /* cursor to get the company(operating units) and the cost method */
645: /* Per the inventory convergence inputs from costing team
646: Sukarna and Uday - there is no need to pass cost method */