APPS.WMS_UT_PKG dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 520: moqdrec mtl_onhand_quantities_detail%ROWTYPE;

516: , p_test_id IN NUMBER)
517: IS
518: -- ,,,,_{,,,,,,
519:
520: moqdrec mtl_onhand_quantities_detail%ROWTYPE;
521: lotrec mtl_lot_numbers%ROWTYPE;
522: serrec mtl_serial_numbers%ROWTYPE;
523:
524: l_last_item VARCHAR2(30);}

Line 548: from mtl_onhand_quantities_detail

544:
545: l_moqd_lst := get_value_list(p_data, 'ONHAND');
546: select *
547: into moqdrec
548: from mtl_onhand_quantities_detail
549: where creation_date > sysdate - 800
550: and organization_id = p_org_id
551: and rownum = 1;
552:

Line 603: insert into mtl_onhand_quantities_detail

599: SELECT MTL_ONHAND_QUANTITIES_S.nextval INTO l_oh_id FROM DUAL;
600:
601: print_debug('Writing to MOQD ID : ' || l_oh_id);
602:
603: insert into mtl_onhand_quantities_detail
604: (INVENTORY_ITEM_ID,
605: ORGANIZATION_ID,
606: DATE_RECEIVED,
607: LAST_UPDATE_DATE,

Line 2681: DELETE FROM mtl_onhand_quantities_detail

2677: DELETE FROM mtl_lot_numbers
2678: WHERE organization_id = p_org_id
2679: AND inventory_item_id = l_item_id;
2680:
2681: DELETE FROM mtl_onhand_quantities_detail
2682: WHERE organization_id = p_org_id
2683: AND inventory_item_id = l_item_id;
2684: print_debug('Deleted ALL Onhand');
2685: