APPS.INV_ITEM_STATUS_CP dependencies on MTL_PENDING_ITEM_STATUS

Line 484: UPDATE mtl_pending_item_status

480: WHERE p1.organization_id = p_Org_Id
481: AND p1.master_organization_id = p2.master_organization_id)));
482:
483: /* End Bug 3713912 */
484: UPDATE mtl_pending_item_status
485: SET pending_flag = 'N' ,
486: implemented_date = SYSDATE ,
487: request_id = G_REQUEST_ID,
488: program_application_id = G_PROG_APPID,

Line 547: FROM mtl_pending_item_status pis,

543: IS
544: SELECT pis.status_code,
545: pis.inventory_item_id,
546: pis.organization_id
547: FROM mtl_pending_item_status pis,
548: mtl_item_status pit
549: WHERE pis.effective_date <= sysdate
550: AND pis.pending_flag = 'Y'
551: AND pis.inventory_item_id = nvl(cp_item_id,pis.inventory_item_id)

Line 572: l_status_code mtl_pending_item_status.status_code%TYPE;

568: SELECT status_control_code
569: FROM mtl_item_attributes
570: WHERE attribute_name = cp_attrib_name;
571:
572: l_status_code mtl_pending_item_status.status_code%TYPE;
573: l_item_id mtl_pending_item_status.inventory_item_id%TYPE;
574: l_org_id mtl_pending_item_status.organization_id%TYPE;
575: l_control_level mtl_item_attributes.control_level%TYPE;
576: l_done BOOLEAN := FALSE;

Line 573: l_item_id mtl_pending_item_status.inventory_item_id%TYPE;

569: FROM mtl_item_attributes
570: WHERE attribute_name = cp_attrib_name;
571:
572: l_status_code mtl_pending_item_status.status_code%TYPE;
573: l_item_id mtl_pending_item_status.inventory_item_id%TYPE;
574: l_org_id mtl_pending_item_status.organization_id%TYPE;
575: l_control_level mtl_item_attributes.control_level%TYPE;
576: l_done BOOLEAN := FALSE;
577: l_counter NUMBER := 1;

Line 574: l_org_id mtl_pending_item_status.organization_id%TYPE;

570: WHERE attribute_name = cp_attrib_name;
571:
572: l_status_code mtl_pending_item_status.status_code%TYPE;
573: l_item_id mtl_pending_item_status.inventory_item_id%TYPE;
574: l_org_id mtl_pending_item_status.organization_id%TYPE;
575: l_control_level mtl_item_attributes.control_level%TYPE;
576: l_done BOOLEAN := FALSE;
577: l_counter NUMBER := 1;
578: