DBA Data[Home] [Help]

APPS.INV_ATTRIBUTE_CONTROL_PVT dependencies on GME_BATCH_HEADER

Line 323: FROM GME_MATERIAL_DETAILS D, GME_BATCH_HEADER H

319: --bug 16227090 start
320: if (l_org_count <> 1) then
321: SELECT count(1)
322: into l_org_count
323: FROM GME_MATERIAL_DETAILS D, GME_BATCH_HEADER H
324: WHERE D.INVENTORY_ITEM_ID = p_item_id
325: AND D.ORGANIZATION_ID = p_org_id
326: AND D.BATCH_ID = H.BATCH_ID
327: AND (NVL(H.GL_POSTED_IND, 0) = 0 AND

Line 457: FROM GME_MATERIAL_DETAILS D, GME_BATCH_HEADER H

453: if nvl(l_master_count, 0) <> 1 then
454:
455: SELECT count(1)
456: into l_master_count
457: FROM GME_MATERIAL_DETAILS D, GME_BATCH_HEADER H
458: WHERE D.INVENTORY_ITEM_ID = p_item_id
459: AND D.ORGANIZATION_ID in
460: (select organization_id
461: from mtl_parameters