DBA Data[Home] [Help]

APPS.AHL_PRD_DISP_UTIL_PVT dependencies on MTL_PARAMETERS

Line 1927: AHL_MC_RELATIONSHIPS rel, MTL_PARAMETERS morgs

1923: CURSOR get_empty_pos_item_csr(p_relationship_id IN NUMBER,
1924: p_org_id IN NUMBER ) IS
1925: SELECT ia.inventory_item_id, mtl.concatenated_segments, ia.quantity, ia.uom_code
1926: FROM AHL_ITEM_ASSOCIATIONS_B ia, MTL_SYSTEM_ITEMS_KFV mtl,
1927: AHL_MC_RELATIONSHIPS rel, MTL_PARAMETERS morgs
1928: WHERE ia.inventory_item_id = mtl.inventory_item_id
1929: AND mtl.organization_id = p_org_id --Make sure item is defined for p_org_id
1930: AND ia.inventory_org_id = morgs.master_organization_id
1931: AND morgs.organization_id = p_org_id

Line 1943: AHL_MC_RELATIONSHIPS rel, AHL_MC_CONFIG_RELATIONS crel, MTL_PARAMETERS morgs

1939: CURSOR get_pos_subut_item_csr(p_relationship_id IN NUMBER,
1940: p_org_id IN NUMBER ) IS
1941: SELECT ia.inventory_item_id, mtl.concatenated_segments, ia.quantity, ia.uom_code
1942: FROM AHL_ITEM_ASSOCIATIONS_B ia, MTL_SYSTEM_ITEMS_KFV mtl,
1943: AHL_MC_RELATIONSHIPS rel, AHL_MC_CONFIG_RELATIONS crel, MTL_PARAMETERS morgs
1944: WHERE ia.inventory_item_id = mtl.inventory_item_id
1945: AND mtl.organization_id = p_org_id --Make sure item is defined for p_org_id
1946: AND ia.inventory_org_id = morgs.master_organization_id
1947: AND morgs.organization_id = p_org_id