DBA Data[Home] [Help]

APPS.GME_CREATE_BATCH_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 423: FROM mtl_system_items_b

419: v_inventory_item_id NUMBER
420: ,v_org_id NUMBER)
421: IS
422: SELECT std_lot_size, primary_uom_code
423: FROM mtl_system_items_b
424: WHERE inventory_item_id = v_inventory_item_id
425: AND organization_id = v_org_id;
426:
427: CURSOR cur_get_doc_ord (v_org_id NUMBER, v_batch_type NUMBER)

Line 1891: FROM mtl_system_items_b

1887: x_batch_header_rec.due_date := p_batch_header_rec.due_date;
1888:
1889: SELECT primary_uom_code
1890: INTO l_prim_item_um
1891: FROM mtl_system_items_b
1892: WHERE inventory_item_id = l_recipe_validity_rule.inventory_item_id
1893: AND organization_id = x_batch_header_rec.organization_id;
1894:
1895: OPEN get_prim_prod (x_batch_header_rec.batch_id